topic Re: Sales - StartDate & EndDate two years comparison in QlikView https://community.qlik.com/t5/QlikView/Sales-StartDate-EndDate-two-years-comparison/m-p/1013967#M943183 <HTML><HEAD></HEAD><BODY><P>What is your current expression for Sales TY?</P></BODY></HTML> Sun, 17 Jan 2016 14:50:47 GMT sunny_talwar 2016-01-17T14:50:47Z Sales - StartDate & EndDate two years comparison https://community.qlik.com/t5/QlikView/Sales-StartDate-EndDate-two-years-comparison/m-p/1013966#M943182 <HTML><HEAD></HEAD><BODY><P>Hi Guys,</P><P></P><P>I'm new at Qlikview and i&nbsp; really like to have the possiblities to use the comparison analysis technics.</P><P>You can see the issue underneath. i would like to see data in the second and third column which based on&nbsp;&nbsp; two comparisons from the startdate &amp; enddate.</P><P></P><P><IMG class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/111795_pastedImage_0.png" style="max-height: 900px; max-width: 1200px;" /></P><P>How can i have data on the second and third column?</P><P></P><P>Thank you and hope to see your reactions soon.</P><P></P><P>Greets,</P><P></P><P>Rega</P></BODY></HTML> Sun, 17 Jan 2016 08:50:24 GMT https://community.qlik.com/t5/QlikView/Sales-StartDate-EndDate-two-years-comparison/m-p/1013966#M943182 2016-01-17T08:50:24Z Re: Sales - StartDate & EndDate two years comparison https://community.qlik.com/t5/QlikView/Sales-StartDate-EndDate-two-years-comparison/m-p/1013967#M943183 <HTML><HEAD></HEAD><BODY><P>What is your current expression for Sales TY?</P></BODY></HTML> Sun, 17 Jan 2016 14:50:47 GMT https://community.qlik.com/t5/QlikView/Sales-StartDate-EndDate-two-years-comparison/m-p/1013967#M943183 sunny_talwar 2016-01-17T14:50:47Z Re: Sales  - StartDate & EndDate two years comparison https://community.qlik.com/t5/QlikView/Sales-StartDate-EndDate-two-years-comparison/m-p/1013968#M943184 <HTML><HEAD></HEAD><BODY><P>sum ({$&lt;Year={$(=Only(Year))}&gt;}TransactionQuantity*SalesPrice)/1000</P></BODY></HTML> Thu, 28 Jan 2016 17:06:33 GMT https://community.qlik.com/t5/QlikView/Sales-StartDate-EndDate-two-years-comparison/m-p/1013968#M943184 2016-01-28T17:06:33Z