Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Top two values in current month comparing the same values with previous month

Hi all Please help me out top two values in current month comparing the same with previous month.

In June the top two profitted cuntries are Argentina and Japan

In May the top two profitted cuntries are America and Argentina

What i want is when i click on jun i want both june and may data to dispaly and the comparision should be between the selected month (jun) and top two values of it  Argentina and Japan to Argentina and Japanin May

32 Replies
sunny_talwar

You want to see this on a bar graph with MONTHYEAR and COUNTRY as dimension?

Not applicable
Author

Yes i want to see the current month top values in comparison to previous months. Or any other way to represent

varshavig12
Specialist
Specialist

Not applicable
Author

My Requirement is actually this if a user selects the current month the higest 2 values in current month

and i want to see how these higest values are in previous 3 months user can select any month
if he selects any month the previous 3 months data should appear

varshavig12
Specialist
Specialist

  Using global grouping,

I got this:

But this is one is showing largest two from the current and the previous two months.

I will try as per your requirement and let you know

varshavig12
Specialist
Specialist

this is ok ?

varshavig12
Specialist
Specialist

Try this.

varshavig12
Specialist
Specialist

Not applicable
Author

Hi its looking great but it was not working in my qvw im bit worried