topic Re: How we can achieve by using alternative state in QlikView

How we can achieve by using alternative state

Wed, 11 Jun 2014 18:10:54 GMT

Hi,

I need to list the top 3 countries whose sales greater than sales of USA,here USA is selected from list box.Suppose if we select UK I need to display 3 countries whose sales greater than sales of UK....and so on.

List box contains 50 countries.

how we can achieve this output by using alternate state instead of set analysis.

Thanks

Swathi

Re: How we can achieve by using alternative state

lironbaram — Wed, 11 Jun 2014 18:38:22 GMT

have a look at the attach example

Re: How we can achieve by using alternative state

Thu, 12 Jun 2014 05:01:48 GMT

Oh unfortunately I am unable to open the qvw because I have personal edition in my desktop.Can you please share explanation here??

Thanks Swathi

Re: How we can achieve by using alternative state

lironbaram — Thu, 12 Jun 2014 05:27:31 GMT

yes

ok after loading the data

i created a list box and assigned it to alternate state

in this list box i allow only one selected value

the value in this list box is the reference country.

i than created a variable named vRefernceSale with this formula

=sum({Alternate1}Sales)

than in a straight table i chose country as the dimension

and used this expression

if(sum(Sales)>vRefernceSale,sum(Sales))

the last step is to define in the dimension limit

show 3 largest values

Re: How we can achieve by using alternative state

Thu, 12 Jun 2014 17:48:06 GMT

Thanku Liron