Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
QlikView Guru's..............Please help e with this.
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
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
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