Skip to main content

Showing Missing Time Data in QV

Related News

US Choropleth Using QlikView Pivot Table

We had some conversations internally around the idea that it might be easier to read...

2 Comments

  1. Mike S

    Another alternative is generating rows for the missing data points, although this may not always be feasible, depending on the data volume and number of dimensions in the fact table. You would be trading longer reload time and larger QVW size for faster front end performance with simpler expressions.

    tempFact:
    LOAD DISTINCT MonthYear,
    MonthYearSort,
    Year,
    Quarter,
    QuarterSort
    RESIDENT Base;

    OUTER JOIN (tempFact)
    LOAD DISTINCT Division
    RESIDENT Base;

    LEFT JOIN (tempFact)
    LOAD *
    RESIDENT Base;

    Fact:
    NOCONCATENATE LOAD Division,
    MonthYear,
    Alt(Sales,0) as Sales,
    MonthYearSort,
    Year,
    Quarter,
    QuarterSort
    RESIDENT tempFact;

    DROP TABLE Base, tempFact;

  2. Anusha

    Not able to Download QVW

Leave a reply

Your email address will not be published. Required fields are marked *