Expression Language

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: 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: 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.

Join me for QlikView Joins

  Correct directions! This is first part on QlikView Joins. In this part, I have covered introduction to Joins and in future parts I will deep dive and explain them with practical examples. I hope this useful! Also, recommend you to participate in QlikShare’s QlikView Question of the Day. I have posted some interesting QlikView Questions(…)

FirstSortedValue function in QlikView – Part II

Hello, Good morning. This is the second part of two part series on FirstSortedValue function. I’d recommend you to watch the first part before watching this video. In this video, I’ll talk about practical scenarios on where we can use FirstSortedValue function. I have demonstrated step-by-step process. Just in case if you can’t watch the video from(…)

Load More