Scripting Language

Optimize the QlikView search functionality on large datasets

Welcome to QlikShare.Com. This post contains a QlikView Video Tutorial. In this video, I’ll show you how to optimize the QlikView search functionality on large datasets. Search object works fast with small datasets but free search is relatively slow on large datasets. I’ll show you a simple technique which is easy to customize yet works(…)

Understanding Concat() Function

Welcome to QlikShare.Com. This post contains a QlikView Video Tutorial. In this video, you’ll learn about Concat() function. I’ve covered both – Scripting & UI with some examples. Leave a comment if you have any questions or tweet me directly. Just in case if you can’t watch the video from this site, you can use(…)

The HAVING clause in QlikView

For those of you, who come from ANSI SQL background know what is the HAVING clause; however, some of the QlikView developers who doesn’t have ANSI SQL background might not understand it. Before we understand what is the HAVING clause let’s first understand what is the WHERE clause.

Using FirstWorkDate() function in QlikView

Time dimension is the most used & common dimension fields in every QlikView application. Whether you have light version master calendar or a full version, you always need to calculate the latest business date based on today or a specific date. As you are aware, there are many ways to calculate the latest business date.(…)

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

Qlik Weekly Updates – May 19th 2014 Edition

1. Qlik Luminary Lunch with Donald Farmer: It was great to meet fellow Qlik Luminaries for lunch with Donald Farmer. We had lunch at Claridge’s in Bond Street. As expected, Donald Farmer gave good insight behind QlikView.Next thinking. Great to meet fellow Luminaries like Stephen Redmond, Steve Dark, Matt Crowther, and Peter Crayfourd. Needless to say(…)

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: Additional features of Today() & Now() functions in QlikView

Welcome to QlikShare.Com. This post contains QlikView Video Tutorial. In this video, we all know Today() & Now() functions in QlikView. However, there are hidden features within these functions. Both these functions accept a parameter and the default parameter is (0). Just in case if you can’t watch the video from this site, you can(…)

QlikView Video Tutorial: LET & SET QlikView Script Statements

QlikView Video Tutorial: LET & SET QlikView Script Statements

Image source: AcsiiVille Comics Welcome to QlikShare.Com. In this video, Let’s understand LET & SET script statements 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 learning.    

Load More