topic Re: Averages in Pivot Table in QlikView

Averages in Pivot Table

Tue, 11 Aug 2015 15:02:44 GMT

I have a straight table (snippet attached) that shows integer values, which is what I want. For each column, I have Total Mode set to Average of Rows. I'd like this average to be limited to say 3 decimal places so that it displays without being masked (with #####). Alternately, I'd like the value to be visually clipped and not masked. Any ideas? Thanks.

Re: Averages in Pivot Table

sunny_talwar — Tue, 11 Aug 2015 15:15:08 GMT

Try this may be:

If(Dimensionality() = 0, Num(yourExpression, '#,##0.000'), Num(yourExpression, '#,##0'))

and set the format to Expression Default on Number's tab

Re: Averages in Pivot Table

Tue, 11 Aug 2015 19:52:47 GMT

Thanks. I'll try it out. One modification I might make is to wrap the Dimensionality() function around the format string itself, so I don't have to copy my expression twice (it's long and unwieldy).

Re: Averages in Pivot Table

sunny_talwar — Wed, 12 Aug 2015 00:10:57 GMT

Ya, that definitely seems like a good idea to test out. Let us know what results you get, I would be very curious to know.

Thanks,

Sunny