• Load latest Excel file to Qlikview

    Hi All,     The below script helps you in loading the latest data from the given folder based on the filename.  The below script helps you in loading the latest year automatically   Example: File...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • Steps for beginners to implement Google Maps in Qlikview

    Find the attachement to implement google maaps in qlikview. Documents with screenshots are avail. Attached the QVW file also for your reference. Regards. Siva Sankar k I've re-edited the document  and fixed the&...
    sivasankar kanagasabai
    last modified by sivasankar kanagasabai
  • Zero to D3 Extension in a few easy steps with an improved template

    Introduction Chapters Pre Reading- The Extension Template: See below or on the blog here: PreReading- Qlikview Extension in a few easy steps and with an improved template – Qlik and Dirty Step1- A bas...
    Adam Davies
    last modified by Adam Davies
  • Qlikview Parameterised Variables

    The Qlikview Variables are quite cool and they can be used as little functions too. For example, the below variable declaration gives the flexibility to use any simple aggregation functions on any fields in the model ...
    Sasidhar Parupudi
    last modified by Sasidhar Parupudi
  • Do you Qualify?- How to use QUALIFY statement

    What it is used for? The Qualify statement is used for switching on the qualification of field names, i.e. field names will get the table name as a prefix.’   In situation where we have two (or more) Ta...
    Robert Mika
    last modified by Robert Mika
  • QvM - Color Management

    "How to reduce time to set up and manage the colors of your dashboard and start creating business value faster?"   Imagine there would be a module that could help set up and manage the colors for your dashboard ...
    Koen Bal
    last modified by Koen Bal
  • QvM - AdHoc table

    The AdHoc table module provides an easy to setup AdHoc table (aka lego table). The dimensions and expressions are managed in the QVMeta_Dashboard excel which is part of the Documentation Module. The possibility to add...
    Koen Bal
    last modified by Koen Bal
  • Display_by_Date_Slider_Alt_State.qvw

    A way of isolating the date dimension via a slider object and alternate state from other default selections. via this cool expression in the dimension for the bar chart:   aggr(only({<SaleDate=P({test})>}...
    gerry castellino
    last modified by gerry castellino
  • Mini Bar Chart inside Straight Table and in List Box

    Hi,   Created a simple document with steps on creating a Mini Bar Chart inside Straight Table and in the Listbox. Hope it helps for the beginners. Your comments are welcome.   - Siva Sankar
    sivasankar kanagasabai
    last modified by sivasankar kanagasabai
  • Variables with Parameters

    Hi Qlikers,   I have been going through certain requirements in my current project which helped me to find variables with parameters. Syntax: if($1 = <value1>, expression1, if($1 = <value2>, expressio...
    Kiran kumar Cherukupally
    last modified by Kiran kumar Cherukupally
  • One Table to Rule Them All

    Introduction   In Business Intelligence and data science there has always been this debate about whether a star schema is better than a snowflake schema or vice versa. This post, is not about that argument. This ...
    Thabang Petje
    last modified by Thabang Petje
  • License_Analyser_K3FDS.qvw

    The QlikView Management Console is a great tool for configuring your QlikView environment, but one thing it is not great at, ironically, is analysing your usage of licenses. In particular analysing your use allocation...
    David Foster
    last modified by David Foster
  • Qlik Sense Waterfall Chart with Bar Chart (without extension)

    A simple approach to get a waterfall chart with a bar chart. Using an offset segment that is set to white and a little bit logic in the load script to be able to read a straight-forward data table.  
    Petter Skjolden
    last modified by Petter Skjolden
  • Reading Data from Sharepoint lists into QlikView

    This is something that's been asked a number of times, so I would like to share this small tip for everyone. interesting in reading data from Sharepoint lists into QlikView. There are a number of ways to extract data...
    John Trigg
    last modified by John Trigg
  • From Date & To Date Selection Script Solution

    Hi Qlikers,   I have written this blog to showcase how from date & to date can be used to select the date ranges in QlikView associative model.   Scenario: Let's say I want to calculate count of emplo...
    kushal chawda
    last modified by kushal chawda
  • Dynamic KPIs

    Sometimes, when you have less space in Dashboard and you have much information/KPIs to show OR If you want to let user to select what specific information he wants to look at rather than pouring all information in das...
    Kamal Kumar Sanguri
    last modified by Kamal Kumar Sanguri
  • Set Analysis for Rolling Periods

    Hi All,   Sometimes there may be requirements from users where they want to see the charts by rolling periods based on the selected periods, please check below for various scenarios.   Note: The format defi...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • Set Analysis: syntaxes, examples

    For those that find this document in a search - you may also want to check out these videos to learn Set Analysis:   A Beginners' Introduction to Set Analysis (video)   About the attached document:   ...
    Michael Tarallo
    last modified by Michael Tarallo
  • Sample data

    You want to create a small qvw to explain a question? Or are you searching for sample data to do some testing?   In attachment you can find all qvds from the following demo applications: Executive dashboard...
    Koen Bal
    last modified by Koen Bal
  • Calculation of MTD, YTD, QTD, WTD in script level - The As-Of table concept - MTD, YTD, QTD, WTD calculation made easy

    Hi, I have prepared a script that will calculate the MTD, YTD, QTD, WTD without using complex set analysis using the As-Of table concept.   Also from my script various types of calculations can be made like cur...
    sandip Ghosh
    last modified by sandip Ghosh