QlikView Scripting

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

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

Five Reasons why a QlikView Developer Should know SQL

Without any doubt we all agree that QlikView is intuitive to use. Not just as a business user, even developing a QlikView application is an intuitive process. However, understanding SQL programming is important because most of the medium/large QlikView applications fetch data from transactional databases or a data warehouse. As a QlikView developer it’s important(…)

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.    

QlikView Video Tutorial: Loading Multiple Excel Files

Welcome to QlikShare.Com. In this video, I’ll show you how to load multiple Excel files in single Load script. We’ll use wildcard character to search for the Excel files. 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