topic Re: How Do I refer to cells in a pivot table? in QlikView

How Do I refer to cells in a pivot table?

Anonymous — Mon, 02 Dec 2013 13:44:34 GMT

Hi I am new to qlikview and I have been playing around with some sales data. I have a pivot table with Year as a Dimension and Sum(sales) as an expression, so I want to figure out the sales variance basically adding another expression that will give the sales variance.. below is an e.g. of a pivot table I have. Thank You in Advance

Year	Sum(Sales)	Sales Variance
2007	1222264.36	????
2008	2572552.27	??
2009	3266290.59	??

Re: How Do I refer to cells in a pivot table?

israrkhan — Mon, 02 Dec 2013 13:55:14 GMT

try this

Above(Sum(Sales))/sum(Sales)

Re: How Do I refer to cells in a pivot table?

saumyashah90 — Mon, 02 Dec 2013 13:58:07 GMT

Dont Increase the complexity by doing it in Expression,

While loading script you can make a new field

Like This You Can Continue With Formula and get over it in Script

Re: How Do I refer to cells in a pivot table?

salto — Mon, 02 Dec 2013 14:05:26 GMT

Hi Saumya,

your point is good, but (correct me if I am wrong), it needs the data to be loaded in the same order as we want it to be displayed in the Pivot Table, doesn' it?

Regards!

Re: How Do I refer to cells in a pivot table?

saumyashah90 — Mon, 02 Dec 2013 14:10:21 GMT

yup correct,
so after this we can also load it in Table Box

Re: How Do I refer to cells in a pivot table?

Anonymous — Tue, 03 Dec 2013 07:27:18 GMT

Hi guys Thank you for your help, I ended up changing the approach to solve my problem. I used Country as my dimension and and added an expression to get 'Year To Date Sales'

Sum ({$<Year = {$(=max(Year)-4)}>}Sales)

I copied it from a demo App I got from Qlikview's website but I am not really sure how this expression really works, please take me through it.

bellow is a screen shot of my pivot table