topic Re: Dimension targeting an other dimension value in QlikView https://community.qlik.com/t5/QlikView/Dimension-targeting-an-other-dimension-value/m-p/1059683#M354894 <HTML><HEAD></HEAD><BODY><P>I have an other issue. If I do that, I can reuse this value in the pivot table as a new expression like:</P><P></P><UL><LI>I create a new expression</LI><LI>I write: (Result previous month)/2, it works</LI></UL><P></P><P>But how can I reuse this value outside the pivot table ? I need that value as an offset in a chart.</P></BODY></HTML> Thu, 24 Mar 2016 12:28:31 GMT 2016-03-24T12:28:31Z Dimension targeting an other dimension value https://community.qlik.com/t5/QlikView/Dimension-targeting-an-other-dimension-value/m-p/1059680#M354891 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I don't understand how I can get rid of that.</P><P></P><P>This is what I have:</P><P><IMG alt="Table.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/119181_Table.png" style="height: 86px; width: 620px;" /></P><P>I want the value of "Result previous month" pointing on the result of the previous month. If Jan, 0. </P><P></P><P>The months are stings values, not dates, but we can eventually work with months as dates.</P><P></P><P>Thanks for your help.</P><P></P><P>Best regards,</P><P></P><P>A</P></BODY></HTML> Wed, 23 Mar 2016 15:47:04 GMT https://community.qlik.com/t5/QlikView/Dimension-targeting-an-other-dimension-value/m-p/1059680#M354891 2016-03-23T15:47:04Z Re: Dimension targeting an other dimension value https://community.qlik.com/t5/QlikView/Dimension-targeting-an-other-dimension-value/m-p/1059681#M354892 <HTML><HEAD></HEAD><BODY><P>Try =Above(result)</P></BODY></HTML> Wed, 23 Mar 2016 16:35:56 GMT https://community.qlik.com/t5/QlikView/Dimension-targeting-an-other-dimension-value/m-p/1059681#M354892 Gysbert_Wassenaar 2016-03-23T16:35:56Z Re: Dimension targeting an other dimension value https://community.qlik.com/t5/QlikView/Dimension-targeting-an-other-dimension-value/m-p/1059682#M354893 <HTML><HEAD></HEAD><BODY><P>Haha didn't know about "table functions".</P></BODY></HTML> Wed, 23 Mar 2016 16:44:55 GMT https://community.qlik.com/t5/QlikView/Dimension-targeting-an-other-dimension-value/m-p/1059682#M354893 2016-03-23T16:44:55Z Re: Dimension targeting an other dimension value https://community.qlik.com/t5/QlikView/Dimension-targeting-an-other-dimension-value/m-p/1059683#M354894 <HTML><HEAD></HEAD><BODY><P>I have an other issue. If I do that, I can reuse this value in the pivot table as a new expression like:</P><P></P><UL><LI>I create a new expression</LI><LI>I write: (Result previous month)/2, it works</LI></UL><P></P><P>But how can I reuse this value outside the pivot table ? I need that value as an offset in a chart.</P></BODY></HTML> Thu, 24 Mar 2016 12:28:31 GMT https://community.qlik.com/t5/QlikView/Dimension-targeting-an-other-dimension-value/m-p/1059683#M354894 2016-03-24T12:28:31Z