Supressing missing values in a chart

[#1]

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

[Mark_Little]

HI,

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

Also suppress zero-values on the presentation tab.

Mark

[Anonymous]

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

See the attachment

[Chanty4u]

or else change the chart type.

[#5]

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

[PradeepReddy]

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

[Anonymous]

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

[#8]

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