topic How to find a specific value in the pivot table in QlikView https://community.qlik.com/t5/QlikView/How-to-find-a-specific-value-in-the-pivot-table/m-p/294394#M1200675 <HTML><HEAD></HEAD><BODY><P>filter in pivot table : select fields A B C</P><P>or</P><P>use Macro to find a value in table</P></BODY></HTML> Thu, 16 Dec 2010 04:20:38 GMT 2010-12-16T04:20:38Z How to find a specific value in the pivot table https://community.qlik.com/t5/QlikView/How-to-find-a-specific-value-in-the-pivot-table/m-p/294393#M1200674 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I am quite new to the QlikView. I do not know how to find a specific value in the pivot table.</P><P>For example, this is a three dimension (A, B, C) pivot table:</P><P>C1 C2 C3</P><P>A1 B1 X1 X2 X3</P><P>B2 X4 X5 X6</P><P>A2 B1 Y1 Y2 Y3</P><P>B2 Y4 Y5 Y6</P><P></P><P>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?</P><P></P><P>Thanks in advance!</P><P></P><P></P></BODY></HTML> Thu, 16 Dec 2010 03:14:24 GMT https://community.qlik.com/t5/QlikView/How-to-find-a-specific-value-in-the-pivot-table/m-p/294393#M1200674 2010-12-16T03:14:24Z How to find a specific value in the pivot table https://community.qlik.com/t5/QlikView/How-to-find-a-specific-value-in-the-pivot-table/m-p/294394#M1200675 <HTML><HEAD></HEAD><BODY><P>filter in pivot table : select fields A B C</P><P>or</P><P>use Macro to find a value in table</P></BODY></HTML> Thu, 16 Dec 2010 04:20:38 GMT https://community.qlik.com/t5/QlikView/How-to-find-a-specific-value-in-the-pivot-table/m-p/294394#M1200675 2010-12-16T04:20:38Z How to find a specific value in the pivot table https://community.qlik.com/t5/QlikView/How-to-find-a-specific-value-in-the-pivot-table/m-p/294395#M1200676 <HTML><HEAD></HEAD><BODY><P>Thanks!</P><P>Problem has been solved</P><P></P><P>Danni</P></BODY></HTML> Thu, 16 Dec 2010 06:11:29 GMT https://community.qlik.com/t5/QlikView/How-to-find-a-specific-value-in-the-pivot-table/m-p/294395#M1200676 2010-12-16T06:11:29Z