Variables

Learn new skills in New Year: QlikView and QlikSense Set Analysis

As a beginner, it’s overwhelming to grasp everything by reading, don’t get me wrong! Reading helps for sure but watching someone doing is easier as we don’t have to visualise it. Anything entirely new – I always prefer learning by watching and listening. When I started learning QlikView, forget about the video course, there wasn’t(…)

QlikView Video Tutorial: Highlight Bar Chart Values based on Current Selections

Welcome to QlikShare.Com. This post contains a QlikView Video Tutorial. In this video, I’ll show you how to highlight the bar chart based on the current selections. This is simple yet very intuitive technique. I’ve used following features/functions to achieve this functionality: Four Functions: Concat(), Match(), GetSelectedCount() and Colour Function(s) IF Statements One Variable Dollar Sign(…)

QlikView Video Tutorial: Restore default selection state after the Clear All event

Welcome to QlikShare.Com. This post contains a QlikView Video Tutorial. Sometimes, you need to restore some default selections after hitting the “Clear All” button. You might need this to restore a default field selection or select a bookmark. You can do this using a hidden option on QlikView desktop client. We can also store a(…)

Qlik Weekly Updates – August 18th 2014 Edition

1. Launch of QlikSense in business world:  I’m sure you already know it! Qlik launched new product called “QlikSense”. There are loads of blog posts by top bloggers and dozens of getting started tutorials on QlikCommunity. As technology enthusiast, you might be focusing on the features, functionality and comparison with other competitive products. However, it’s(…)

QlikView Video Tutorial: Include the variables while creating a bookmark

Welcome to QlikShare.Com. This post contains QlikView Video Tutorial. In this video, let’s see – how to include variables while creating a bookmark. By default, QlikView will not save the variable state while creating the bookmark. But there’s an option to include the variables while creating the bookmark, which we will see in this video.(…)

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: 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: Scope of Variables in QlikView

  Welcome to QlikShare.Com. In this video, I’ll quickly explain you about the scope of variables. Qlik variables are interesting because of dollar sign expansion ($). 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.

Dynamic Connection String in QlikView

In this video, Let’s understand how to create Dynamic Connection String in QlikView. Following are the advantages of using this approach. Easy to maintain the Connection String(s) Additional security because Connection String is stored outside QlikView document Flexibility to change the Server Name, Database Name and User Name Easy to switch from Test to Development(…)

Load More