topic Re: Set analysis variable in QlikView

Set analysis variable

MauriceLudo — Thu, 20 Jul 2017 15:27:05 GMT

Hi,

Here is the expression to calculate the percentage

- count(DISTINCT {< Mois={'févr.'}, [Canal d'entrée]={'Accès web','Formulaire web'}>} [Prise de contact]) = 270

- $(vMoyenneAnnuelle) = count(DISTINCT {<[Canal d'entrée]={'Accès web','Formulaire web'}>} [Prise de contact])/ Count({<Année = {'$(=Max(Année))'}>} Distinct Mois) = 312

- num(count(DISTINCT {< Mois={'févr.'}, [Canal d'entrée]={'Accès web','Formulaire web'}>} [Prise de contact])/ $(vMoyenneAnnuelle),'00,##%') = 2.40%

- 270/312=86.53%

I can not identify the error, could you help me please?

Thank you

Maurice

Re: Set analysis variable

sunny_talwar — Thu, 20 Jul 2017 15:29:55 GMT

What do you get when you use just this

$(vMoyenneAnnuelle)

and

vMoyenneAnnuelle

If one of these give you your 312, use that for the denominator.

Re: Set analysis variable

vishsaggi — Thu, 20 Jul 2017 15:32:39 GMT

Try this?

= num(count(DISTINCT {< Mois={'févr.'}, [Canal d'entrée]={'Accès web','Formulaire web'}>} [Prise de contact])/ '$(vMoyenneAnnuelle)','00,##%')

Re: Set analysis variable

Anil_Babu_Samineni — Thu, 20 Jul 2017 15:33:05 GMT

Can you try with this?

Num(Expression * 100 , '##.#0%')

Re: Set analysis variable

MauriceLudo — Thu, 20 Jul 2017 15:47:51 GMT

- $(vMoyenneAnnuelle) : give me 312

- vMoyenneAnnuelle : nothing

But I use this expression already, as mentioned above

Re: Set analysis variable

MauriceLudo — Thu, 20 Jul 2017 15:48:19 GMT

does not work

Re: Set analysis variable

MauriceLudo — Thu, 20 Jul 2017 15:50:59 GMT

It is not the percentage display the problem

Re: Set analysis variable

sunny_talwar — Thu, 20 Jul 2017 15:53:12 GMT

What do you see when you use it without the formatting?

count(DISTINCT {< Mois={'févr.'}, [Canal d'entrée]={'Accès web','Formulaire web'}>} [Prise de contact])/ $(vMoyenneAnnuelle)

Do you see 0.8653?

Re: Set analysis variable

MauriceLudo — Thu, 20 Jul 2017 15:56:41 GMT

document attached

Re: Set analysis variable

MauriceLudo — Thu, 20 Jul 2017 15:57:06 GMT

0.024038

This is my problem

Re: Set analysis variable

sunny_talwar — Thu, 20 Jul 2017 16:09:01 GMT

Which object are we doing this in?

Re: Set analysis variable

MauriceLudo — Thu, 20 Jul 2017 16:16:26 GMT

the first object

Thank you

Re: Set analysis variable

sunny_talwar — Thu, 20 Jul 2017 16:21:35 GMT

I don't see this variable?

vMoyenneAnnuelle

Sorry, but I think your sample seems to be a little different then what you mentioned above. Would you be able to reconcile between the two?

Re: Set analysis variable

MauriceLudo — Thu, 20 Jul 2017 16:29:39 GMT

Sorry i have changed

the new variable vTestT

Re: Set analysis variable

sunny_talwar — Thu, 20 Jul 2017 17:14:53 GMT

This worked

=(count(DISTINCT {< Mois={'févr.'}, [Canal d'entrée]={'Accès web','Formulaire web'}>} [(Ne pas modifier)Prise de contact]))/ ($(vTestT))