Load Script Keywords

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.

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

QlikView Video Tutorial: Everyone Loves Subfield (QlikView Subfield Function)

  Welcome to QlikShare.Com. In this video, we’ll learn about Subfield function in QlikView. This function works in both script & UI and it’s one of my favourite function 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(…)

QlikView Video Tutorial: Group By Clause in QlikView

  Welcome to QlikShare.Com. In this video, let’s understand Group By clause and how to use it in the QlikView script. 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: Invoke Qlikview Using Command Prompt/ Batch Files

Welcome to QlikShare.Com. In this video, I’ll show how to invoke QlikView using command prompt/batch files. We’ll see how to use various command line switches 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: Auto Generate Preceding Load Statement in QlikView Script

Welcome to QlikShare.Com. In this video, we’ll see how to auto generate the preceding load statement in QlikView script. This will be very useful technique when you have too many fields in the QlikView application. Just in case if you can’t watch the video from this site, you can use this link to watch from YouTube. Thank(…)