Expression Language

Mastering QlikView Set Analysis

Mastering QlikView Set Analysis

Every Qlik (View and Sense) developer must know Set Analysis. There are loads of articles on Qlikcommunity, and the good old reference manual has information on Set Analysis. However, the content on QlikCommunity is dispersed and hard to locate when you most need. Plus, reading Set Analysis is hard because of its syntax. When I(…)

Advanced Filters: QlikView Design Principle

Before building a dasbhboard or QlikView app, developer must consider the technical challenges relating to successful app design. Failing to build an app with such technicalities in mind could result in an app that many users find unprofessional and difficult to use. Technical issues here doesn’t mean data model challenges or writing complex expressions, we(…)

Client Side Error Logging: QlikView IE-Plugin

I’m sure most of you, if not everyone are aware about the QlikView server logging. There are variety of logs available to manage and debug QlikView Server and Publisher. As a QlikView developer, you use the QVW logs to debug the script errors. Recently I had been dealing with the IE-Plugin stability and performance issues.(…)

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

Qlik Weekly Updates – February 16th 2015 Edition

1. Qlik acquires NPrinting: Finally, it happened – I’m very pleased to see that Qlik still respects PixelPerfect reporting requirements. We’ve two main stream products – NPrinting and CIA reports for Pixel perfect reporting. Qlik has acquired Vizubi and its NPrinting product line, the market-leading report generation, distribution, and scheduling application for QlikView. A Qlik(…)

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

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

Load More