topic Using above row data in Pivote table in QlikView

Using above row data in Pivote table

vijay_iitkgp — Tue, 20 Dec 2011 05:48:26 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

Using above row data in Pivote table

vijay_iitkgp — Tue, 20 Dec 2011 06:24:15 GMT

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

Using above row data in Pivote table

sridhar240784 — Tue, 20 Dec 2011 07:38:06 GMT

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

Using above row data in Pivote table

vijay_iitkgp — Tue, 20 Dec 2011 08:01:02 GMT

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

Re: Using above row data in Pivote table

sridhar240784 — Tue, 20 Dec 2011 08:17:12 GMT

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