• 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
  • Bollinger Bands

    Hi Qlikers,   This document demonstrates the Bollinger Bands.   Many traders use Bollinger Bands to determine overbought and oversold levels, selling when price touches the upper Bollinger Band and buying ...
    kushal chawda
    last modified by kushal chawda
  • 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
  • How to use- Dual()

    Have you ever wonder how the examples from the Qlikview help may look like? Please see below and enjoy responsibly...   Dual()   Definition: Forced association of an arbitrary string representation s with a...
    Robert Mika
    last modified by Robert Mika
  • 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
  • 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
  • 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
  • Control Chart

    What is Control Chart? The control chart is a statistical analysis used to study how a process changes over time. Data are plotted in time order. Control charts are used to routinely monitor quality or simply you can...
    kushal chawda
    last modified by kushal chawda
  • Compare Current Period with Previous Period Mistake

    A common metric with a business is to compare  current period with previous period a over same number of days. few fall into mistake of comparison of current period with the whole previous period.  Take for...
    Ziad Mohammad
    last modified by Ziad Mohammad
  • Connectivity to Oracle Database

    Useful connectivity documentation from QlikView to Oracle Databases
    Sulaiman Yusuf
    last modified by Sulaiman Yusuf
  • Useful Qlikview Macros

    Hope the below macro scripts helps beginners Source : QlikView Macros – Useful collection | Lucian Cotea   1) Run external program: FUNCTION RunExe(cmd) CreateObject("WScript.Shell").Exec(cmd) END FUNCTION...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • Fiscal Calendar with Non-Standard Days (Not 1-31)

    Hi All, Hope the below script helps for those who are looking for a Fiscal Calendar for non standard dates.  For example the month starts from 26 th of previous month to 25th of current month.   Jan-2015: ...
    jagan mohan rao appala
    last modified by jagan mohan rao appala
  • Date Level Analysis - WTD, MTD, QTD & YTD (Current Year & Previous Year)

    Hello Friends, WTD (Week To Date), MTD(Month To Date), QTD (Quarter To Date) & YTD(Year To Date) are commonly used for any kind of analysis. Below are some expression which you can use while doing the same: &n...
    Rahul Pawar
    last modified by Rahul Pawar