Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
vhespinog
New Contributor III

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

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

1 Solution

Accepted Solutions

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

Are you looking to get this?

image.png

2 Replies

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

Are you looking to get this?

image.png

vhespinog
New Contributor III

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

Thank you!, works fine