Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Re: Filling in data gaps with zero values

Hi Daniel

You need a reference table with all days, and then join with your desire table, like this:

Reference_Table:

LOAD

    REF_DATE as DATE

FROM

    <your_reference_file.xls>;

Your_Table:

Inner Join(Reference_Table)

LOAD

    [Header 1] as DATE,

    [Header 2] as hValues

FROM

    <your_file.xls>;

After that:

   

change the missing values to "0", and then Supress Zero-Values and try this options:

  • ALT( hValues, 0 ) as new_hValues  or..
  • if(hValues='-',0,hValues) as new_hValues

Best Regards,

Anderson

Community Browser