Scripting Language

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.

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: 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: User Defined Functions in QlikView using Dollar Sign Expansion

Welcome to QlikShare.Com. In this video, we’ll see how to create user defined functions in QlikView. We’ll use dollar sign expansion and double dollar sign expansion based on the input expression. This is very powerful technique to pass in parameters while creating custom functions. Just in case if you can’t watch the video from this(…)

QlikView Video Tutorial: CrossTable in QlikView (Transpose your data!)

Welcome to QlikShare.Com. In this video, I’ll show you how to transpose data in QlikView. We’ll see how to use the CrossTable table operator 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. Sample Code: CrossTable(My_Attribute_Name, My_Attribute_Value,2(…)

QlikView Video Tutorial: The Having Clause in QlikView

Welcome to QlikShare.Com. In previous video, we’ve explored Group By clause in QlikView. In this video, let’s understand more about The Having Clause 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.

Load More