topic Specifying a default value for missing data in QlikView

Specifying a default value for missing data

Wed, 28 Jul 2010 17:57:24 GMT

I have a report for which I generate a 'Master Calendar'. For dates in the future for which I have no data yet for a particular field expression I want to populate a default value. On a chart how can I specify a default value to use when no value is present in my source database? What I really want to do is pull a default value from my database and use this in places where there isn't specific data available for a particular date.

Specifying a default value for missing data

Wed, 28 Jul 2010 19:25:28 GMT

I dont know what you want.....

but you can do this in script .....for example.....IF(ISNULL(your field), 'put a default value' , your field)

or on the chart

you can enable a POPULATE MISSING CELLS

and put you default value in a fields Null Symbol or/and Missing Symbol...

did you tray that??

Specifying a default value for missing data

Thu, 29 Jul 2010 13:44:16 GMT

Using the conditional in the expression worked. Earlier I had tried this but had a logical error that was causing things not to display as I wanted.

Specifying a default value for missing data

Fri, 15 Apr 2011 12:47:03 GMT

Great.. I used it as an calculated dimension. In a case where you had male, female, -. Where the '-' needed to be replaced by 'Unknown'.