We all know that QlikView works based on WYSIWYG principle. It’s very important to focus on little details which makes the difference. Attention to detail is not just key aspect while crunching the numbers, but it’s equally important to take care of little things which are visible to end users. In this video, I’m(…)
Join me for QlikView Inner Joins (Part 2)
This is the second part on QlikView Joins. In this part, I have covered Inner Join in QlikView, Logical Understanding of the Inner Join and using Venn diagram. Basic rules of Joins: Join Predicate in QlikView is Automatic i.e. Common field names between two tables If you have more than one common fields in both(…)
Custom OnClearAll document event in QlikView
CLEAR ALL!! very useful feature in QlikView. However, sometimes you don’t wish to clear everything in your data model. Suprisingly there is no event assigned to this user action. In this video, I’ll show you how to trigger the Clear All event in QlikView. I’ll be using following tools… ConcatFunction (As string builder) IF (Boolean(…)
Join me for QlikView Joins
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 particpate in QlikShare’s QlikView Question of the Day. I have posted some interesting QlikView Questions to challenge(…)
How to drop script variables in QlikView?
Welcome to QlikShare.com. I wish all of you happy new year. In this Video, I’ll show you how to drop script variables in QlikView. In QlikView, variables persist after the script execution and sometimes you don’t need in them in UI. I mean you might want to use variable while executing the script and drop(…)
Remove NULLs by Mapping Load & Map Using statements in QlikView…
Welcome back to QlikShare.Com. I’m posting after long time and hopefully I’ll continue to make more video tutorials. In this video, I’ll show you how to remove NULL values by Mapping Load & Map Using statements. As you know, NULL values are always an issue of concern while building QlikView applications. You’ll be happy to(…)
Google Analytics API integration within QlikView (Part 1)
As promised, I have created a series of video tutorials on how to integrate Google Analytics (ga) data within QlikView. This is the first part and in this video I’ll provide high-level overview on Google Analytics architecture. As mentioned in the video, I’d strongly recommend using QV Source because they have done great job with(…)
Pick Function in QlikView
In this video, I’ll talk about Pick function in QlikView. This works as Index function in Excel. I’d encourage you to watch Match() function video to use them in conjuction. Please take time to leave feedback or rate the video. I need your feedback to improve the quality. Thanks in anticipation. Just in case if(…)
Load Order using InLine Load
In this video, I’ll talk about importance of Load Order. Load Order is relevant to many aspects of QlikView. Load Order is used for default sorting, setting color order & functions like FieldValue() and FieldIndex(). Please take time to leave feedback or rate the video. I need your feedback to improve the quality. Thanks in(…)