Qlikview Set Analysis on Selected Month

[z_badawi]

When a user selects a month in the multi-box I have provided, for the field named 'month', I want to filter the chart's data to that month only. How can I do that?

I know that Date#(month) returns the selected month but can't seem to use it correctly in set analysis.

Thanks.

[Taoufiq_Zarra · Accepted solution]

if your expression is sum(Sales)

then your new expression will be :

=Sum({<Month={"$(=Max(Month))"}>} Sales)

[z_badawi]

Thanks a lot for your help.

Could you please tell me how I can do the same thing but for the month before the selected month? (example: user selects February, I want to apply set analysis on January)

[Taoufiq_Zarra]

if you have a date field then :

=Sum({<Date= {"$(=Addmonths(Date,-1))"}>} Sales)