Learn QlikView

Five words QlikView Developers should never say…

  Large/ Huge: Whenever you walk into a meeting room with the Business Analysts, Managers or Business Users who might ask how big is the application or data set? Don’t say it’s small/large/huge. Instead give the numbers because the words “small”,  “large” and “huge” are subjective to each person. Instead go prepared with the numbers ready in(…)

Qlik Weekly Updates – December 8th 2014 Edition

1. Fox Sports using QlikView to improve sales performance:  Fox Sports Pulse has deployed a solution using Qlik to analyse customer registration and purchase data to improve sales performance. It’s interesting to broad range of customers who use QlikView. According Mathew Lalor, General Manager, Finance for Fox Sports Pulse said – “There’s no question that our sales opportunities(…)

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

This is the second part of two part blog post about QlikView CAL management. Let’s understand how do CALs/licenses work together… Qlikview Server can support any combination of different CALs in a single Qlikview Server. Often it makes sense to combine the different CALs in a single Qlikview server based on the user requirements. When CALs(…)

QlikView Video Tutorial: Moving Chart Legends in QlikView

Welcome to QlikShare.Com. This post contains a QlikView Video Tutorial. Sometimes, you may wanted to move chart legends from rows to columns. There is no special setting in the chart object properties. However, this can be done by snapping the legend frame. Check the video demo for more understanding. Just in case if you can’t(…)

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.

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

Qlik Weekly Updates – June 23rd 2014 Edition

1. Coming Soon – Qlik Business Discovery Word Tour: Qlik announced that Business Discovery World Tour (BDWT) London 2014 will be held on Tuesday 21st and Wednesday 22nd October 2014 at Kings Place in London. According to Qlik, this conference will include keynote speakers, Qlik subject matter expert presentations, a Partner Showcase and opportunities to network(…)

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: Scrambling QlikView Data

Welcome to QlikShare.Com. This post contains QlikView Video Tutorial. In this video, we will understand and see – how to use scrambling 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