Solved: Average in text box - Page 2 - Qlik Community

Report Inappropriate Content · ‎2011-10-12

Hi.

I have a pivot table contains of two demintions dates and departments and the expression is Sum() sales for everyday.

I am trying to get the average for sales per day in a text box and it is not giving me the correct data.

Report Inappropriate Content · ‎2011-10-12

everyone of the above is giving me different resaults but none of them is correct!!

Thank you guys for your help!

its_anandrjs · ‎2011-10-12

Hi,

I suggest try this

Avg( Aggr ( Avg ( num(Sales,'#,##0.##') ),Dimension X ) )

Rgds

Anand

Report Inappropriate Content · ‎2011-10-12

Thank you guys! fixed

you rock!

its_anandrjs · ‎2011-10-12

Hi,

Thanks I am glad to help you.

Rgds

Anand

Average in text box