Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

zied_ahmed1
Contributor III

problem with a pivot table and set analysis

Hello I have a pivot table and i would like to display the average of Sum(Taux) but i have a wrong value :

problem.PNG

for example in avr i must have a value near to 23,64% and in mai i need to have a value close to 100%

and this is the set analyses used for this

if(Dimensionality()=1, Avg(Aggr(Sum(Taux), Plaque_flotte)),sum(Taux))

Regards

6 Replies

Re: problem with a pivot table and set analysis

Can you try this

Avg(Aggr(Sum(Taux), Plaque_flotte))

zied_ahmed1
Contributor III

Re: problem with a pivot table and set analysis

Hello Sunny,

nope.PNG

this is the result of your set analysis there is no values in mai and the value in avr are wrong...

Re: problem with a pivot table and set analysis

Would you be able to share a sample?

Re: problem with a pivot table and set analysis

You have three dimensions in your chart

Avg(Aggr(Sum(Taux), Plaque_flotte, Dimension2, Dimension3))

I saw that your dimension3  (month) is a calculation... carry that out in the script and use that here

zied_ahmed1
Contributor III

Re: problem with a pivot table and set analysis

yes i do this but the average is still wrong ...

wrong.PNG

Re: problem with a pivot table and set analysis

Did you take your third dimension to the script?

Month(Date) as Month? and use Month in the aggr() function

Community Browser