topic Re: Dynamic Barchart has input from list box in QlikView

Dynamic Barchart has input from list box

Wed, 11 Dec 2013 14:14:31 GMT

Hi,

I have the requirement like countries in x-axis and sum(sales) in y axis.

i have list box contains 30 countries,

Requirement is like this:

list the top 4 countries whose sales greater than sales of 'india'.Here 'india' is selected from list box item.

suppose i select 'UK' from list box items.Let me know how to proceed for solution.input data must be from list box.

regards

Mahesh

Re: Dynamic Barchart has input from list box

jerem1234 — Wed, 11 Dec 2013 15:00:21 GMT

See if attached is what you are looking for. I used Country as dimension with the expression:

if(sum({1}Sales)>$(=max(aggr(sum(Sales), Country))), sum({1}Sales))

Then used dimension limits to only show Top 4 countries.

Hope this helps!

Re: Dynamic Barchart has input from list box

Anonymous — Wed, 11 Dec 2013 15:11:26 GMT

Mahesh,

See attached. The solution is based on
- a variable vCountry which is defined by =only({Alt1} Country)
- a list box Country in Alternate State Alt1
- calculated dimension in the chart
- dimension limits set to largest 4.

Not clear what you want to get. The largest four are always the same. Except, if you select one of the largest in the list, than the number of the largest will be less than four. Maybe you need to clarify the requirements...

Regards,
Michael