Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

Highlighted
Not applicable

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

Highlighted
Specialist
Specialist

Highlighted
Not applicable

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

Highlighted
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

Highlighted
Specialist
Specialist

this is ok ?

Highlighted
Specialist
Specialist

Try this.

Highlighted
Specialist
Specialist

Highlighted
Not applicable

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