This content has been marked as final. Show 2 replies
I am quite new to the QlikView. I do not know how to find a specific value in the pivot table.
For example, this is a three dimension (A, B, C) pivot table:
C1 C2 C3
A1 B1 X1 X2 X3
B2 X4 X5 X6
A2 B1 Y1 Y2 Y3
B2 Y4 Y5 Y6
I want to calculate Y1/X1, Y4/X1, Y2/X2, Y5/X2, Y3/X3, Y6/X3... In that case, I need to find the value (X1) with dimension A=A1, B=B1, and C=C1. Do you have any idea how I can find the specific value in pivot table?
Thanks in advance!