topic Pivot Table - Base 100 data in QlikView https://community.qlik.com/t5/QlikView/Pivot-Table-Base-100-data/m-p/269309#M580585 <HTML><HEAD></HEAD><BODY><P> Hello.</P><P></P><P>I have a pivot table with 2 dimensions. First one is Date, second one is Product.<BR />I would like to show the evolution of Products' Prices starting from 100 (rebased data).</P><P></P><P>Attached is the table that I would like to get. I have been trying to achieve this using First() function, but no luck...</P><P></P><P>Many thanks for your help.</P></BODY></HTML> Thu, 12 Jan 2012 11:05:32 GMT Anonymous 2012-01-12T11:05:32Z Pivot Table - Base 100 data https://community.qlik.com/t5/QlikView/Pivot-Table-Base-100-data/m-p/269309#M580585 <HTML><HEAD></HEAD><BODY><P> Hello.</P><P></P><P>I have a pivot table with 2 dimensions. First one is Date, second one is Product.<BR />I would like to show the evolution of Products' Prices starting from 100 (rebased data).</P><P></P><P>Attached is the table that I would like to get. I have been trying to achieve this using First() function, but no luck...</P><P></P><P>Many thanks for your help.</P></BODY></HTML> Thu, 12 Jan 2012 11:05:32 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Base-100-data/m-p/269309#M580585 Anonymous 2012-01-12T11:05:32Z Pivot Table - Base 100 data https://community.qlik.com/t5/QlikView/Pivot-Table-Base-100-data/m-p/269310#M580586 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Have you tried using set analysis? </P><P></P><P>Can you attach the QVW? At least for me, it is easier to help working on a sample QVW rather than talking conceptually.</P><P></P><P></P><P>Regards,</P><P>Fernando</P></BODY></HTML> Thu, 12 Jan 2012 17:17:20 GMT https://community.qlik.com/t5/QlikView/Pivot-Table-Base-100-data/m-p/269310#M580586 fosuzuki 2012-01-12T17:17:20Z