topic Re: Exclude unwanted calculated dimension in QlikView

Exclude unwanted calculated dimension

tamilarasu — Tue, 30 Dec 2014 06:17:35 GMT

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.

Re: Exclude unwanted calculated dimension

jagan — Tue, 30 Dec 2014 06:30:59 GMT

Hi,

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

Regards,

Jagan.

Re: Exclude unwanted calculated dimension

tamilarasu — Tue, 30 Dec 2014 06:53:35 GMT

Perfect .

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