Level-II

All you need to know about QlikView CAL(s) – Part I

What is a CAL A QlikView license is referred to as a Client Access License (commonly called as CAL). To access the QlikView Dashboards deployed in QlikView Server, users need a Client Access License (CAL).  The CALs are purchased with QlikView Server and tied to the QlikView Server Serial Number. A CAL is never transferred to a client, but(…)

Convert multiple date formats into one date format using Alt() function

Most of the times, we don’t get clean data. Especially the data from web or non-transactional systems where there is no data integrity or constraints, which will have some noise. Let’s assume that we have single date field which has multiple date formats (As shown below).     Currently, “MyDateField” field has 4 different date(…)

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 Video Tutorial: Convert QlikView Null Values to Selectable Strings

Welcome to QlikShare.Com. This post contains QlikView Video Tutorial. In this video, we will see – how to use NullAsValue statement in QlikView Script to convert NULL values to selectable strings. 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: 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: 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(…)

QlikView Video Tutorial: Concatenate & NoConcatenate Operators in QlikView

Welcome to QlikShare.Com. In this video, I’ll explain you about Concatenate & NoConcatenate table operators. These operators are similar to Union table operator in ANSI SQL. 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: 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.

Load More