PIVOT CALCULATION PROBLEM

Tue, 28 Jul 2009 19:50:32 GMT

Hi there I have a problem calculating columns on pivot tables:

I have 1 column named TOT WEEK for each date i select in the pic below I have 2 dates (17/07/2009 and 24/07/2009).

being selection dinamic I can have more columns and different dates. I would like to add a column for each date which gives me the difference between values of tot week. In the example below I was playin with columnNO and Column which I tried for the purpose of my calculation.

In the example i qwould like to get a new coulm which will result: (Value TOT week for date 24/07/09)-(Value TOT week for date 24/07/17) in this case 0-44= - 44

I tried column (2) - coumn (1) but it gives no result......

Thank you

for the help

Alex

PIVOT CALCULATION PROBLEM

vidyut — Tue, 28 Jul 2009 20:17:50 GMT

Hi,

As it is a Pivot table, actually the two columns are two rows internally. So you might be better off If you use Above/Below/Before/After Functions.

PIVOT CALCULATION PROBLEM

Thu, 30 Jul 2009 20:29:55 GMT

THNX it worked!

topic PIVOT CALCULATION PROBLEM in QlikView

PIVOT CALCULATION PROBLEM

PIVOT CALCULATION PROBLEM

PIVOT CALCULATION PROBLEM