topic Using dimensions and expresions in a pivot table in QlikView https://community.qlik.com/t5/QlikView/Using-dimensions-and-expresions-in-a-pivot-table/m-p/155193#M31533 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a pivot table which has a few dimensions. I need to use the value of one of these to calculate another one.</P><P>Eg</P><P>dimension 1 = min(a1)</P><P>dimension 2 = $ nnn corresponding to min(a1)</P><P>Does anyone have a suggestion?</P><P></P></BODY></HTML> Tue, 10 Aug 2010 19:14:52 GMT 2010-08-10T19:14:52Z Using dimensions and expresions in a pivot table https://community.qlik.com/t5/QlikView/Using-dimensions-and-expresions-in-a-pivot-table/m-p/155193#M31533 <HTML><HEAD></HEAD><BODY><P>Hi</P><P>I have a pivot table which has a few dimensions. I need to use the value of one of these to calculate another one.</P><P>Eg</P><P>dimension 1 = min(a1)</P><P>dimension 2 = $ nnn corresponding to min(a1)</P><P>Does anyone have a suggestion?</P><P></P></BODY></HTML> Tue, 10 Aug 2010 19:14:52 GMT https://community.qlik.com/t5/QlikView/Using-dimensions-and-expresions-in-a-pivot-table/m-p/155193#M31533 2010-08-10T19:14:52Z Using dimensions and expresions in a pivot table https://community.qlik.com/t5/QlikView/Using-dimensions-and-expresions-in-a-pivot-table/m-p/155194#M31534 <HTML><HEAD></HEAD><BODY><P>Well, as far as I know the only way you can do this is by reentering the entire previous dimension into your second dimension. I think you should consider moving the logic for the first dimension to the load script...</P><P>Regards,</P></BODY></HTML> Wed, 11 Aug 2010 05:07:52 GMT https://community.qlik.com/t5/QlikView/Using-dimensions-and-expresions-in-a-pivot-table/m-p/155194#M31534 vgutkovsky 2010-08-11T05:07:52Z