Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

kishoresai
New Contributor

Line Chart


Hi,

Please find the attached qvw file

I need to create a line chart

one line for Dell should be for default

and I need 3 more line of Top 3  Vendors

I tried using rank,aggr and sum but still I am not able to create it

Thank you.

3 Replies
jerem1234
Valued Contributor II

Re: Line Chart

See if attached is what you are looking for. Used dimensions of Quarter and Vendor with the expression:

sum({<Vendor = {'Dell', '=match(aggr(rank(sum(Share)), Vendor), 1, 2, 3)'}>}Share)

Hope this helps!

kishoresai
New Contributor

Re: Line Chart

Thanks for the help

But if we make selections in country level the graph has to display default +top 3 for that country

jerem1234
Valued Contributor II

Re: Line Chart

This should work for selections of country. Did you mean you want it to display the Top 3 no matter what country is selected?

Try this:

sum({1<Vendor = {'Dell', '$(=firstsortedValue({1}Vendor, aggr(rank(sum({1}Share)), Vendor)))',

'$(=firstsortedValue({1}Vendor, aggr(rank(sum({1}Share)), Vendor), 2))',

'$(=firstsortedValue({1}Vendor, aggr(rank(sum({1}Share)), Vendor), 3))'}>}Share)

Hope this helps!

Community Browser