Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to display the latest two month in this case?

I am trying to show the last 2 months of data on a line chart as picture below but I do not know on how to do it. Appreciate if someone could help me to slove this problem.


Thanks,

Shahana


Capture.PNG

3 Replies
sunny_talwar

So you want to see month 11 and 12? May be set analysis or calculated dimension

Anonymous
Not applicable
Author

Thank for your reply Sunny.

Yes. i just wanna show month 11 and 12 only.  I had tried set the dimension as below and it still not functioning.

Sum({$<Month={1,2}>} [Action Required])

sunny_talwar

If you want 11 and 12... why are you using 1 and 2 in set analysis? Also, you mentioned dimension... are you using this as dimension or expression?