Monthly Archives: May 2012

Wildcard Search by using Like Operator in QlikView

Hello, In this video, I have demonstrated on how to perform Wildcard Search by using Like Operator in QlikView. If you come from database background then you’d find it easy to understand. Although, it’s pretty straight-for-ward to understand. Update : sfatoux spotted potential logical bug. We should use ‘*(sa)*’ instead of ‘*sa*’ to make the search(…)

QVD Generator using For..Next Loop in QlikView – Part II

Hello, This is the second part of two part tutorials on generating QVDs using For…Next Loop in QlikView. In this video I have covered practical demonstration. I’m also including the script for your understanding and please message me if you need the QVW file. Please take time to leave feedback or rate the video. I(…)

QVD Generator using For..Next Loop in QlikView – Part I

Hello, This is the first part of two part tutorials on generating QVDs using For…Next Loop in QlikView. In this video I’ll cover theoretical concepts which includes :  Introduction to For…Next Loop  Directory Statement in QlikView  Sub…End Sub Statements in QlikView  Store Statement in QlikView In the next video I’ll explain the script in-detail and(…)

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(…)

FirstSortedValue function in QlikView – Part I

Hello Today, let’s talk about FirstSortedValue function in QlikView. This function can be used as both chart expression and script expression. However in this tutorial, I’m going to focus on using it as chart expression. I have divided this tutorial in two parts and this first part of two part series. In this part, I’ll(…)