topic Display Months When No Data Present in QlikView

Display Months When No Data Present

Anonymous — Thu, 25 Mar 2010 02:08:14 GMT

I should think this would be easy but I can't figure it out. If you look at the attached screenshot you'll see that I've got a simple data set of customer sales by month. All I want is to have the chart always show twelve months in the axis, even if the selected customer has no sales in some months.

Display Months When No Data Present

Oleg_Troyansky — Thu, 25 Mar 2010 02:24:08 GMT

Brian,

uncheck "Suppress zero values" and "Suppress Missing" on the Presentation tab of the chart.

Display Months When No Data Present

Anonymous — Thu, 25 Mar 2010 03:08:04 GMT

Those two properties were the first I tried. No effect.

Display Months When No Data Present

Oleg_Troyansky — Thu, 25 Mar 2010 03:19:17 GMT

Brian,

check that you have the missing Months as field values in a Calendar or somewhere else. Try also checking "Show All Values" , in combination with "Suppress when value is null" for the Dimension.

See attached sample

Display Months When No Data Present

Anonymous — Thu, 25 Mar 2010 03:29:35 GMT

No, still isn't working. I must be missing something obvious which will, no doubt, make me feel like an idiot when someone figures it out. I'm attaching the app if you don't mind taking a look.

Display Months When No Data Present

Anonymous — Thu, 25 Mar 2010 04:46:50 GMT

Brian, It's due to the calculated dimension. It's actually showing "all" values as the values for the dimension are the ones available at the moment in the field Fiscal_Date_Period.

Create this dimension on the script side already and you should be good with Show All Values and unchecking Suppress zero-values like Oleg pointed out.

Display Months When No Data Present

Anonymous — Thu, 25 Mar 2010 05:12:39 GMT

That did it, thanks Johannes. I never even thought it would be that. Weird idiosyncrasy or working as designed? Who knows.