Exclude unwanted calculated dimension

[tamilarasu]

Hi All,

I got a problem while working on a pivot chart. I have created a expression dimension field, so that the days can be displayed dynamically in chart. If I select Jan month in a list box, the chart showing the total sum correctly. But If I select the months other than January, extra dimension automatically generated by Qlikview which not required (Sum of previous months. Say for ex, My selection is March then the column generated the sum value of Jan and Feb).

  

Anyone have idea why this happening.?

Thank you.

[jagan · Accepted solution]

Hi,

Select Suppress When Value is Null option in Dimension and  in Presentation tab uncheck Populating Missing Cells.

Regards,

Jagan.

[tamilarasu]

Perfect .

Thanks a lot.!!!!!!!!!!