topic Percent count in a pivot in QlikView

Percent count in a pivot

Thu, 07 Oct 2010 08:53:11 GMT

I have a pivot table with two columns. In the first column i make a count of the abonnees. How can i get the percent of that counts in the second column from the total abonnees of that row.

Who can help me with this problem?

Percent count in a pivot

Thu, 07 Oct 2010 09:14:25 GMT

HI,

You try this:


=Num( Count(Aantal)/Count(Total Aantal) * 100, 0.00) & '%'

Regards

Percent count in a pivot

Thu, 07 Oct 2010 09:32:17 GMT

=Num(Count(Klantnummer_BC)/Count({<VertegenwoordigerId={'2'}>}Total Klantnummer_BC))

This one works only for the first column. How can i make {<VertegenwoordigerId={'2'}>} variable so he takes the columnvalue?

Percent count in a pivot

Thu, 07 Oct 2010 09:43:58 GMT

Hi Dirk

I didn't get your idea on this one.


dirkgroen wrote:
 How can i make {<VertegenwoordigerId={'2'}>} variable so he takes the columnvalue?
<div></div>

You want to save the value of Vertegenwoordigerid in a variable?

Percent count in a pivot

Thu, 07 Oct 2010 09:51:30 GMT

i need the total of abbonements of that VertegenwoordigerID

Percent count in a pivot

Thu, 07 Oct 2010 10:06:34 GMT

HI,

Ahh.. ok.. how about adding '$' in to your expression:


=Num(Count(Klantnummer_BC)/Count({$<VertegenwoordigerId={'2'}>}Total Klantnummer_BC))

Percent count in a pivot

Thu, 07 Oct 2010 10:32:08 GMT

When i hardcoded set de vertegenwoordigerID on 2 it works for the first. But not for the others. so VertegenwoordigerId needs to be variable and abonnementen not.

Percent count in a pivot

Thu, 07 Oct 2010 10:50:06 GMT

This is the sollution.

=Num(Count(Klantnummer_BC)/Count(Total <VertegenwoordigerId> Klantnummer_BC))

Thanks anyway

Percent count in a pivot

Thu, 07 Oct 2010 10:50:27 GMT

Hmm.. can you share to us your file? (or a sample of it) so that we can help you more