topic Re: Set analysis Product using rate in QlikView

Set analysis Product using rate

Wed, 12 Dec 2012 18:57:25 GMT

Hello,

I've a hierachical dimenssion composed of 3 dimensions (Direction commercial \ Nom Secteur \ Libelle Agence) and I would like to calculate the customers products using rate (<Count of Customer using a product> / <Count of customer at hierachical level>) for each level.

Can you help me to compute the count of customer for each level in table (red column) and chart .

Thanks

Re: Set analysis Product using rate

Gysbert_Wassenaar — Wed, 12 Dec 2012 19:12:20 GMT

Try count(total <$(vG) > [N-Personne]) with a helper variable vG with value ='['&GetCurrentField([>>Maillage])&']'

Re: Set analysis Product using rate

Clever_Anjos — Wed, 12 Dec 2012 20:52:58 GMT

First, rename your group, I think GetCurrentField didn´t like your '>>' name

I renamed to HG_Maillage and used the below expression:

if(GetCurrentField(HG_Maillage) = 'Direction commerciale',

count(total <[Direction commerciale]> [N-Personne]),

if(GetCurrentField(HG_Maillage) = 'Nom Secteur',

count(total <[Nom Secteur]> [N-Personne]),

count(total <[Libelle Agence]> [N-Personne]),

)

Re: Set analysis Product using rate

Thu, 13 Dec 2012 14:10:30 GMT

It looks good. Thank you very much