topic Re: Global grouping in line chart in App Development

Global grouping in line chart

sogloqlik — Sun, 23 Jan 2022 15:33:36 GMT

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

Re: Global grouping in line chart

Qrishna — Mon, 24 Jan 2022 03:49:11 GMT

Is this something you looking for?

Re: Global grouping in line chart

sogloqlik — Mon, 24 Jan 2022 05:44:07 GMT

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

Re: Global grouping in line chart

Qrishna — Mon, 24 Jan 2022 05:50:16 GMT

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.

Re: Global grouping in line chart

Qrishna — Mon, 24 Jan 2022 05:59:03 GMT

Is this Clear?

Re: Global grouping in line chart

sogloqlik — Mon, 24 Jan 2022 06:02:46 GMT

That is what i was looking for.

And the way to achieve it is?

Re: Global grouping in line chart

Qrishna — Mon, 24 Jan 2022 06:24:11 GMT

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

Re: Global grouping in line chart

sogloqlik — Mon, 24 Jan 2022 07:03:36 GMT

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

Re: Global grouping in line chart

Qrishna — Mon, 24 Jan 2022 07:08:00 GMT

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.

Re: Global grouping in line chart

sogloqlik — Mon, 24 Jan 2022 07:13:02 GMT

Can You post the idea?

Re: Global grouping in line chart

Qrishna — Mon, 24 Jan 2022 07:14:34 GMT

the idea is in the qvw.

Re: Global grouping in line chart

Qrishna — Mon, 24 Jan 2022 07:16:39 GMT

for more clearer solution, you can check the qvf from here https://community.qlik.com/t5/New-to-Qlik-Sense/Limit-line-chart-dimension-by-top-5-values/m-p/1310235