Using above row data in Pivote table

[vijay_iitkgp]

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

[vijay_iitkgp]

QlikView Guru's..............Please help e with this.

[sridhar240784]

Hi,

Could you pls post a sample application and explain us,what filter condition your using to filter data from D1 field and what is your ecpected o/p.

-Sridhar

[vijay_iitkgp]

It could be any filter like region, Country, State, Product type . For any of filter I want all D1 dimension from 1 to 10 even if there is no transaction for that value.

For example if  I select Region South and there is no transaction for this region for D1value 5 then  it should show the dimension value 5 with av\bove row data (ie Dimension value 4 data).

Hope i\this will explain .

Regards

VIjay

[sridhar240784]

Not sure, i have understood your query.

Go to Property-->Dimensions and check "Show All Values". This will show all combination of values in dimension.

Have a look at the attached screen print.

-Sridhar