topic Re: TOTAL function in chart in QlikView

TOTAL function in chart

pepe2209 — Tue, 10 Dec 2013 15:08:15 GMT

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

Re: TOTAL function in chart

Tue, 10 Dec 2013 15:13:33 GMT

Hi,

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

Re: TOTAL function in chart

pepe2209 — Tue, 10 Dec 2013 15:22:46 GMT

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.

Re: TOTAL function in chart

Tue, 10 Dec 2013 15:28:47 GMT

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

Re: TOTAL function in chart

Tue, 10 Dec 2013 15:30:44 GMT

Ok, then you test this .....

( {1} ) in this way you consider ALL

Re: TOTAL function in chart

pepe2209 — Tue, 10 Dec 2013 15:39:05 GMT

Ah yes thanks!

this is exactly what i need.

thanks again.