Monthly Archives: July 2014

Book Review: QlikView Server and Publisher by Stephen Redmond

  QlikView administrators have to know little about a lot of things which includes the following: How to install or upgrade QlikView server Managing licensing & CALs How to manage and secure the QVWs Understanding of Windows server architecture & tools How to monitor and troubleshoot QlikView server Most of the times, QlikView developers wear(…)

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

Qlik Weekly Updates – July 07th 2014 Edition

1. QlikView 11.20 SR7 is now available: QlikTech announced SR7 for QlikView 11.20. SR7 introduced the following… Direct Discovery Enhancements Task performance summary Support for document administrator group with cross domain groups CAL allocation audit added to QlikView server event log

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