Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

I want to present only the last 3 months (dimension) in a line diagram

I presented the months in de x-axis en the results of the months (number of prints) in de Y-axis.

I want to limit the x-axis to last tree months. How do I do that?

1 Solution

Accepted Solutions
giovanneb
Creator II
Creator II

Hi try this, use set analysis

sum({1<OrderDate={">=$(=addmonths(monthend(max(OrderDate))+1,-3)) <=$(=max(OrderDate))"}>}Sales)

View solution in original post

3 Replies
giovanneb
Creator II
Creator II

Hi try this, use set analysis

sum({1<OrderDate={">=$(=addmonths(monthend(max(OrderDate))+1,-3)) <=$(=max(OrderDate))"}>}Sales)

Anonymous
Not applicable
Author

hy Giovanne, thanks for your reply. I had a lot of struggle with the notation. For now, it seems to works. Thanks

giovanneb
Creator II
Creator II

Please if suggestion answered wax the topic marked the correct answer.

Regards