topic Re: Supressing missing values in a chart in QlikView

Supressing missing values in a chart

Tue, 16 Feb 2016 05:27:30 GMT

Hi ,

I have a scenario where I need to suppress the missing values in a bar chart. The chart has 2 dimensions. The second dimension has missing values but appear in the chart with no bars. Is there a way I can hide them from appearing in the chart?

Please find the attached QVW file.

Load * Inline
[
Year,Quarter,Amount
2011,Q1,10000
2011,Q2,12000
2011,Q3,30000
2011,Q4,50000
2012,Q1,10000
2012,Q2,20000
];

Here the values for Q3 and Q4 are not present for the Year 2012. Q3 and Q4 must not appear in the bar chart.

Thanks,

Amrutha

Re: Supressing missing values in a chart

Mark_Little — Tue, 16 Feb 2016 08:35:40 GMT

HI,

Have you ticked Suppress when value is null on the Dimensions tab?

Also suppress zero-values on the presentation tab.

Mark

Re: Supressing missing values in a chart

Anonymous — Tue, 16 Feb 2016 08:41:25 GMT

Remove your 2nd expression which is set by you to 1

See the attachment

Re: Supressing missing values in a chart

Chanty4u — Tue, 16 Feb 2016 08:45:15 GMT

or else change the chart type.

Re: Supressing missing values in a chart

Tue, 16 Feb 2016 10:24:36 GMT

Supress nulls in the dimensions and suppress missing properties are checked.

Re: Supressing missing values in a chart

PradeepReddy — Tue, 16 Feb 2016 11:21:29 GMT

as pointed by balraj, remove the 2nd expression which gives you the desired output

Re: Supressing missing values in a chart

Anonymous — Tue, 16 Feb 2016 11:36:49 GMT

To remove the second expression in your expression tab than the problem is sloved

Re: Supressing missing values in a chart

Tue, 16 Feb 2016 12:21:30 GMT

We have to use multiple expressions in chart to achieve the desired results in my scenario.So just posted a sample data set here.