topic Set analysis- Sum current date vs 11 previous months with YearMonth dimension in QlikView

Set analysis- Sum current date vs 11 previous months with YearMonth dimension

vhespinog — Sat, 16 Nov 2024 04:48:31 GMT

Hello,

I need to create a bar chart with YearMonth Dimension. The expression = current month + 11 previous months

I'm using this set:

=sum({$<YearMonth={">=$(=MonthStart(Max(YearMonth),-11))<=$(=MonthEnd(Max(YearMonth)))"},Year=,Month=>}Sales)

if I put it in a textBox with one YearMonth selected works but in my graph doesn't

The test dats is attached

Thanks in advance

sunny_talwar — Wed, 09 Jan 2019 18:27:53 GMT

Are you looking to get this?

vhespinog — Wed, 09 Jan 2019 20:01:24 GMT

Thank you!, works fine