Hello, In this video we will look at the function – ApplyMap() along with Mapping Load in QlikView. This function works similar to VLookup() in Excel. There are few things to remember before you start using ApplyMap() function. Use this function when you wanted to extract only one field from a lookup table First column(…)
Hello, In this video we will look at the scripting function Previous() in QlikView. This function returns the value using data from previous input record. This function will exclude the records which are discarded in the where clause(). In the previous video we have already seen how to use the Peek() function. Remember, unlike Peek()(…)
In this video we will look at the scripting function – Peek() in QlikView. This returns the field value from a specific field. You can specify the row number you wanted to extract and also the table name. This is very powerful scripting fuction in QlikView. Just in case if you can’t watch the video(…)
This video is short demonstration on how to create dimenesion groups in QlikView. There are two types of groups which are Drill-down group and Cyclic group. Drill-down groups are used for hierarchical data and Cyclic groups are used for non-hierarchical data. Thank you for watching. Happy learning.