topic Re: Average in QlikView

Average

Anonymous — Wed, 25 Jun 2014 20:36:38 GMT

Hi guys,

Please help me with idea how to calculate TOTAL average "Overall experience" only for text tags in "Main Issue" field.

I have a list box, where a customer can select any tags of "Main Issue".

The data is below

I used an expression

Avg(TOTAL {<[Main issue]=,[Main issue]=P()>}[Overall experience])

it works right until selection any tag from "Main issue"

Cheers,

Gysbert_Wassenaar — Thu, 26 Jun 2014 07:48:45 GMT

I don't really understand what result you expect. Can you post some examples? Maybe this works: Avg({1<[Main issue]={'*'}>}[Overall experience])

Anonymous — Thu, 26 Jun 2014 13:21:19 GMT

Thanks, It works. I just modified for a chart

=Avg({<[Main issue]={'*'}>} TOTAL [Overall experience])