Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.
Hello I have a pivot table and i would like to display the average of Sum(Taux) but i have a wrong value :
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))
Can you try this
this is the result of your set analysis there is no values in mai and the value in avr are wrong...
Would you be able to share a sample?
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
yes i do this but the average is still wrong ...
Did you take your third dimension to the script?
Month(Date) as Month? and use Month in the aggr() function