Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Qlikview Set Analysis on Selected Month

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.

Labels (2)
1 Solution

Accepted Solutions
Highlighted
Master
Master

if your expression is sum(Sales)

then your new expression will be :

=Sum({<Month={"$(=Max(Month))"}>} Sales)
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

3 Replies
Highlighted
Master
Master

if your expression is sum(Sales)

then your new expression will be :

=Sum({<Month={"$(=Max(Month))"}>} Sales)
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉

View solution in original post

Highlighted
Contributor II
Contributor II

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)

Highlighted
Master
Master

if you have a date field then :

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

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉