topic Re: Most valuable dimension in QlikView

Most valuable dimension

Wed, 16 Jan 2013 13:48:58 GMT

Hi,

say I have the follwing table:

I'm looking for 2 expression:

1. point out the Country with the most customers (=US)

2. % of the total = 560 / 658 = 85%

Is this possible in Qlikview?

oh, preferably as chart expression...

Thanks!

Dror

fosuzuki — Wed, 16 Jan 2013 13:58:13 GMT

Check the attached qvw.

Hope this helps

Fernando

Wed, 16 Jan 2013 14:01:55 GMT

wow that was fast. stil i miss the expression that points out the country name = "US"

MayilVahanan — Wed, 16 Jan 2013 14:05:06 GMT

Try like this

1.Sum({<Country={'US'}>} #Customers)

2.Sum({<Country={'US'}>} #Customers)/Sum(total #Customers)

Wed, 16 Jan 2013 14:09:59 GMT

Thanks. but this is assuming i know infront that the US has the largest customer base. I'm looking for expression that can determine it for me

flipside — Wed, 16 Jan 2013 14:11:33 GMT

This will give you the Country with most Customers based on selection. Just pair it with Fernando's solution.

=FirstSortedValue(Country,-aggr(sum(#Customers),Country))

flipside

swuehl — Wed, 16 Jan 2013 14:15:02 GMT

If your data is like in Mayil's sample app, i.e. the number of Customers is already aggregated per Country in field #Customers, you can use

=FirstSortedValue( Country , -#Customers) & ' : ' & num( max(#Customers) / sum(#Customers),'00,00 %')

Wed, 16 Jan 2013 15:06:13 GMT

This is it. THANKS!!!!!