2 Replies Latest reply: Dec 16, 2010 1:11 AM by danniliang RSS

    How to find a specific value in the pivot table

      Hi,

      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!