Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
pepe2209
Creator
Creator

TOTAL function in chart

Hello

I have a chart with dimension variable: LastYear (per month)

Now I want to show one line with the average of Value of the selected ID(s): avg(Value)

and one line which shows the average of Value over all ID's: avg(TOTAL <LastYear> Value) ??

But this is not working, with this expression the result is still limited to the ID selection and I want it to be an average over all ID's no matter the ID selection.

is this possible?

your help would be much appreciated

regards

Peter

1 Solution

Accepted Solutions
Not applicable

Ok, then you test this .....

( {1} )  in this way you consider ALL

View solution in original post

5 Replies
Not applicable

Hi,

you can to use the set analysis ..... {<ID=>}  in this way, not applicate the filter criteria on ID field.

pepe2209
Creator
Creator
Author

Ok thanks, this indeed works when I make a selection in the field ID

But ID is not the only field in which i can make selections... so i want the total average to work no matter ANY selection made.

Not applicable

avg( {1} Value ), 1 there will ignore all the selections and includes the dimensions in your  chart.

Not applicable

Ok, then you test this .....

( {1} )  in this way you consider ALL

pepe2209
Creator
Creator
Author

Ah yes thanks!

this is exactly what i need.

thanks again.