Using Above row data in Pivote table

vijay_iitkgp — Mon, 19 Dec 2011 08:21:50 GMT

Hi,

I am creating a pivote table with 2 dimension D1(Vertical) and D2(Horizontal) which is using expression value of above row + Some new values . For this I am usin Rangesum(Expr...).

D1 D2 A B C

1 10 25 12

2 18 36 28

3 23 47 37

4 30 53 49

5 47 60 58

6 49 69 63

7 55 80 77

8 55 87 79

9 55 87 83

10 55 87 87

This works fine. But when I use some filter it removes D1 values for which there is no corrosponding transaction for that selection and the values doesnot appear correct in the chart. I have found one workaround by including Dummy data for every possible selections with 0 value but it is increasing my application Size exponentially. Is there any other way to do this ? Hope I have explained my question correctly.

Vijay

topic Using Above row data in Pivote table in QlikView

Using Above row data in Pivote table