topic Average in pivot table in QlikView

Average in pivot table

anuradhaa — Thu, 03 Dec 2015 11:42:32 GMT

I have sales data based on salesman and city.

I need to display it in pivot table and get averages

City	A	B
Salesman
AA	avg	avg
BB	avg	avg
	Avg of City A	Avg of City B

and i'm using previous days data

i use below expression, but figures are wrong

=ceil(Avg({$<date={"=date>=Date(ReloadTime()-1,'DD-MM-YYYY')"},type={"I"}>}

((sales)), 0.01)

Thanks

Re: Average in pivot table

MK_QSL — Thu, 03 Dec 2015 11:56:43 GMT

Sample data or sample application please !

Re: Average in pivot table

anuradhaa — Thu, 03 Dec 2015 12:00:40 GMT

see attached

Re: Average in pivot table

Kushal_Chawda — Thu, 03 Dec 2015 12:02:04 GMT

try

=ceil(Avg({$<date={"$(=date(ReloadTime()-1,'DD-MM-YYYY'))"},type={"I"}>}

sales), 0.01)

=ceil(Avg({$<date={"$(=date(ReloadTime()-1,'DD-MM-YYYY'))"},type={"I"}>}

total <City> sales), 0.01)

Re: Average in pivot table

nagarjuna_kotha — Thu, 03 Dec 2015 12:05:45 GMT

PFA

Re: Average in pivot table

jonathandienst — Thu, 03 Dec 2015 12:09:54 GMT

The sample SOURCE data is totally unhelpful. Your query is about a QV sheet object. You need to upload the qvw model or a sample containing the object and displaying the problem.

I suspect that it is to do with the fact that a pivot table does not sum the rows, it applies the expression to the total data set - and this value may not be the same as the sum of rows. If you post a useful sample qvw doc you will get more specific and useful help.