Global grouping in line chart

[sogloqlik]

Hi all.

I have a line chart with two dims: Year and product, and sales as Measure.
I want to show the top 4 product but in total sales over the years, not the top 4 each year.
How can I achieve that?

Thx

[Qrishna]

Is this something you looking for?

[sogloqlik]

Hi Krishna

The attached example is to small to see the difference in colors in the line chart but..

If the bar chart represents the total sales for 2019-2021 then I should see C-F only (I don't need to see the others option) in the line chart even if (for example) product A sold more in 2019

[Qrishna]

Yes, the line chart shows only top 4 only(as you can see 4 lines and not 6). I showed bar chart with 6 products for you to see the difference between both charts as they both have different number of products. The below bar chart has all the 6 products but the line chart has top 4(what you need, from the question u asked). let me provide some other view instead of bar chart.

[Qrishna]

Is this Clear?

[sogloqlik]

That is what i was looking for.

And the way to achieve it is?

[Qrishna]

PFA. for Top 4 products - check settings in 'Dimension Limits' tab.

[sogloqlik]

We have QlikSense. This is A QlikSense forum....

[Qrishna]

I know. i cannot create a qvf on my local. the above was to give you an idea. you gotta take care as per  your requirement.

[sogloqlik]

Can You post the idea?