topic Re: Line Chart in QlikView

Line Chart

Anonymous — Fri, 21 Mar 2014 18:16:45 GMT

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.

jerem1234 — Fri, 21 Mar 2014 18:40:58 GMT

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!

Anonymous — Fri, 21 Mar 2014 18:53:09 GMT

Thanks for the help

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

jerem1234 — Fri, 21 Mar 2014 19:25:04 GMT

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!