Scripting

Understanding Concat() Function

Welcome to QlikShare.Com. This post contains a QlikView Video Tutorial. In this video, you’ll learn about Concat() function. I’ve covered both – Scripting & UI with some examples. Leave a comment if you have any questions or tweet me directly. Just in case if you can’t watch the video from this site, you can use(…)

The HAVING clause in QlikView

For those of you, who come from ANSI SQL background know what is the HAVING clause; however, some of the QlikView developers who doesn’t have ANSI SQL background might not understand it. Before we understand what is the HAVING clause let’s first understand what is the WHERE clause.

Using FirstWorkDate() function in QlikView

Time dimension is the most used & common dimension fields in every QlikView application. Whether you have light version master calendar or a full version, you always need to calculate the latest business date based on today or a specific date. As you are aware, there are many ways to calculate the latest business date.(…)

Convert multiple date formats into one date format using Alt() function

Most of the times, we don’t get clean data. Especially the data from web or non-transactional systems where there is no data integrity or constraints, which will have some noise. Let’s assume that we have single date field which has multiple date formats (As shown below).     Currently, “MyDateField” field has 4 different date(…)

QlikView Developer Skill Set

QlikView developers come from different backgrounds & skills. Generally speaking, we can divide QlikView developers into two categories: Organic & Tailor-made. Organic QlikView developers come from one of the streams – Traditional BI/ETL Developer, Database Developer, Data Analyst, Excel Developer, Web Developer, Test Analyst, Business Analyst and a DBA. Coming from one of these streams(…)

QlikView Video Tutorial: Convert QlikView Null Values to Selectable Strings

Welcome to QlikShare.Com. This post contains QlikView Video Tutorial. In this video, we will see – how to use NullAsValue statement in QlikView Script to convert NULL values to selectable strings. Just in case if you can’t watch the video from this site, you can use this link to watch from YouTube. Thank you for watching. Happy(…)

QlikView Video Tutorial: Additional features of Today() & Now() functions in QlikView

Welcome to QlikShare.Com. This post contains QlikView Video Tutorial. In this video, we all know Today() & Now() functions in QlikView. However, there are hidden features within these functions. Both these functions accept a parameter and the default parameter is (0). Just in case if you can’t watch the video from this site, you can(…)

QlikView Video Tutorial: LET & SET QlikView Script Statements

QlikView Video Tutorial: LET & SET QlikView Script Statements

Image source: AcsiiVille Comics Welcome to QlikShare.Com. In this video, Let’s understand LET & SET script statements in QlikView. Just in case if you can’t watch the video from this site, you can use this link to watch from YouTube. Thank you for watching. Happy learning.    

QlikView Video Tutorial: Loading Multiple Excel Files

Welcome to QlikShare.Com. In this video, I’ll show you how to load multiple Excel files in single Load script. We’ll use wildcard character to search for the Excel files. Just in case if you can’t watch the video from this site, you can use this link to watch from YouTube. Thank you for watching. Happy learning.

QlikView Video Tutorial: Turn Off Automatic prj Folder creation

Welcome to QlikShare.Com. In previous video, we’ve seen how to create PRJ folder in QlikView. In this video, I’ll show you how to turn off automatic creation of PRJ folders in QlikView. Just in case if you can’t watch the video from this site, you can use this link to watch from YouTube. Thank you for watching.(…)

Load More