topic Re: Qlikview Set Analysis on Selected Month in QlikView

Qlikview Set Analysis on Selected Month

z_badawi — Sat, 16 Nov 2024 01:32:01 GMT

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.

Re: Qlikview Set Analysis on Selected Month

Taoufiq_Zarra — Sat, 11 Jan 2020 18:11:16 GMT

if your expression is sum(Sales)

then your new expression will be :

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

Re: Qlikview Set Analysis on Selected Month

z_badawi — Sat, 11 Jan 2020 18:21:38 GMT

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)

Re: Qlikview Set Analysis on Selected Month

Taoufiq_Zarra — Sat, 11 Jan 2020 18:30:32 GMT

if you have a date field then :

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