topic Dynamic Bar chart based on list box input values in QlikView

Dynamic Bar chart based on list box input values

Wed, 11 Dec 2013 09:43:21 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

Nicole-Smith — Wed, 11 Dec 2013 18:25:32 GMT

See the attached example. Make sure to look at the Dimensions, Dimension Limits, and Expression tabs of the bar chart.

Thu, 12 Dec 2013 10:24:42 GMT

Find the solution in attached qvw.

Though there may be many others ways, I have used Alternate states.

Regards,
Prabhu

Thu, 12 Dec 2013 10:38:17 GMT

U can use the below expression..

=if(Sum(Sales) >Sum({1<Field={"$(=getfieldselections(Field))"}>} Sales),Sum(Sales))

Regards,

Kabilan K.