Hide Bars in Full Acuumulated Bar Chart

Tue, 21 Aug 2012 07:11:05 GMT

Hello,

I've a bar chart with dim YearMonth & expression as

sum({$<

YearMonth={">=$(=Date(addmonths(Max(YearMonth), 1),'MMM YY')) <=$(=Date(addmonths(Max(YearMonth), 1111),'MMM YY'))"}>}

Amount) +

sum({$<YearMonth={">=$(=Date(addmonths(Max(YearMonth), -200),'MMM YY')) <=$(=Date(addmonths(Max(YearMonth), 0),'MMM YY'))"}>} Amount)

and checking full accumulation for this expression.

When selection is made in YearMonth e.g. Jan 2012 then, the bar graph should show the first bar as Feb 2012 showing the sum of Amount from the min. YearMonth available (-200 used in set analysis for this) till the selected YearMonth Feb 2012 (0 used in set analysis).

The subsequent bars should show Mar 2012 (from the min. YearMonth till Mar 2012), Apr 2012 (from the min. YearMonth till Apr 2012).

Right now it shows all the bars before the selected YearMonth also, i would like to hide them.

I think i'm doing something wrong here but can't figure out what.

Plz help

Re: Hide Bars in Full Acuumulated Bar Chart

rajni_batra — Tue, 21 Aug 2012 10:38:42 GMT

When you use full accumalation it will show bar of all previous values whose values are getting accumulating you cant hide those, i think so.

topic Hide Bars in Full Acuumulated Bar Chart in QlikView

Hide Bars in Full Acuumulated Bar Chart

Re: Hide Bars in Full Acuumulated Bar Chart