https://community.qlik.com/t5/QlikView/Multiple-expression-for-each-dimension-value-in-straight-table/m-p/1702795#M451313 <P>Hello,</P><P>I need to represent below data in a straight table.</P><P>The tittle column would be be a inline/excel load.</P><P>In the below scenario each tittle value has a different logic for calculation.</P><P>Currently i create three expression's to display Çurrent Year'value for corresponding dimension value.</P><P>How can 'Previous Year' and 'Difference ' be represented?</P><P>&nbsp;</P><P>&nbsp;</P><TABLE width="569"><TBODY><TR><TD width="290">Tittle</TD><TD width="114">Current Year</TD><TD width="92">Previous Year</TD><TD width="73">Difference</TD></TR><TR><TD>Gross margin / Tel .Sales %</TD><TD>500</TD><TD>400</TD><TD>100</TD></TR><TR><TD>Gross margin / Concession Sales %</TD><TD>600</TD><TD>500</TD><TD>100</TD></TR><TR><TD>Gross margin / Main Stores Sales %</TD><TD>900</TD><TD>300</TD><TD>600</TD></TR></TBODY></TABLE> Sun, 17 May 2020 08:01:29 GMT AKS_Qlik 2020-05-17T08:01:29Z https://community.qlik.com/t5/QlikView/Multiple-expression-for-each-dimension-value-in-straight-table/m-p/1702795#M451313 <P>Hello,</P><P>I need to represent below data in a straight table.</P><P>The tittle column would be be a inline/excel load.</P><P>In the below scenario each tittle value has a different logic for calculation.</P><P>Currently i create three expression's to display Çurrent Year'value for corresponding dimension value.</P><P>How can 'Previous Year' and 'Difference ' be represented?</P><P>&nbsp;</P><P>&nbsp;</P><TABLE width="569"><TBODY><TR><TD width="290">Tittle</TD><TD width="114">Current Year</TD><TD width="92">Previous Year</TD><TD width="73">Difference</TD></TR><TR><TD>Gross margin / Tel .Sales %</TD><TD>500</TD><TD>400</TD><TD>100</TD></TR><TR><TD>Gross margin / Concession Sales %</TD><TD>600</TD><TD>500</TD><TD>100</TD></TR><TR><TD>Gross margin / Main Stores Sales %</TD><TD>900</TD><TD>300</TD><TD>600</TD></TR></TBODY></TABLE> Sun, 17 May 2020 08:01:29 GMT https://community.qlik.com/t5/QlikView/Multiple-expression-for-each-dimension-value-in-straight-table/m-p/1702795#M451313 AKS_Qlik 2020-05-17T08:01:29Z https://community.qlik.com/t5/QlikView/Multiple-expression-for-each-dimension-value-in-straight-table/m-p/1702894#M451320 <P>Hi,</P><P>I would do a pick/match like below/attached toy application, but sounds like you already have something for Current Year, so what does that look like?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="20200517_1.png" style="width: 999px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/33825i4DC44D487EAFFD0C/image-size/large?v=v2&amp;px=999" role="button" title="20200517_1.png" alt="20200517_1.png" /></span></P><P>Cheers,</P><P>Chris.</P> Sun, 17 May 2020 18:17:44 GMT https://community.qlik.com/t5/QlikView/Multiple-expression-for-each-dimension-value-in-straight-table/m-p/1702894#M451320 chrismarlow 2020-05-17T18:17:44Z