Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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