topic Variable choice with list box in QlikView

Variable choice with list box

Tue, 14 Jun 2011 13:49:17 GMT

Hi Everyone,

Attached is my example. I have set some variables with the set that I need to include in the set analysis. I can use them individually in the Static column as you can see, but when I try and make it based on what is in the Base field I can't get the syntax working. Anyone got any ideas?

Just to be clear, when a user selects USA I want the vUSA variable to be used in the set analysis which would give {'USA'}.

Thanks

Gareth

Re: Variable choice with list box

Tue, 14 Jun 2011 14:45:06 GMT

Hi Gareth:

Try this expression for Choice:

=Sum(Visits) / Sum({<Country={$(=Replace(Concat(DISTINCT Choice, ','), ' + ', ','))}>} TOTAL Visits)

Logic: Have been extracting the unique "Country" values and using that list in Set analysis.

Thanks,

Narasimha K

Re: Variable choice with list box

Wed, 15 Jun 2011 07:46:50 GMT

Thanks mate this works a treat!