topic Comparison previous year in case date is a dimension in QlikView https://community.qlik.com/t5/QlikView/Comparison-previous-year-in-case-date-is-a-dimension/m-p/1288183#M849249 <HTML><HEAD></HEAD><BODY><P>I have a problem, i would like to have situation 2 as result, by using a set expression. but for some reason i'm not able to do this.</P><P></P><P>Is this possible to get S2 with set analysis ?</P><P></P><P><IMG alt="Testing.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156252_Testing.png" style="height: auto;" /></P><P></P><P>So far the only solution i can image is loading the dataset twice and once with year+1 as year and costumers as costumers LY and once with year as year and costumers as costumers CY and then join both dataset on the year field.</P><P></P><P>But due to the large dataset it aint possible, so i wonder wether it is possible using set analysis</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT 2020-11-25T16:16:04Z Comparison previous year in case date is a dimension https://community.qlik.com/t5/QlikView/Comparison-previous-year-in-case-date-is-a-dimension/m-p/1288183#M849249 <HTML><HEAD></HEAD><BODY><P>I have a problem, i would like to have situation 2 as result, by using a set expression. but for some reason i'm not able to do this.</P><P></P><P>Is this possible to get S2 with set analysis ?</P><P></P><P><IMG alt="Testing.png" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/156252_Testing.png" style="height: auto;" /></P><P></P><P>So far the only solution i can image is loading the dataset twice and once with year+1 as year and costumers as costumers LY and once with year as year and costumers as costumers CY and then join both dataset on the year field.</P><P></P><P>But due to the large dataset it aint possible, so i wonder wether it is possible using set analysis</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Comparison-previous-year-in-case-date-is-a-dimension/m-p/1288183#M849249 2020-11-25T16:16:04Z Re: Comparison previous year in case date is a dimension https://community.qlik.com/t5/QlikView/Comparison-previous-year-in-case-date-is-a-dimension/m-p/1288184#M849251 <HTML><HEAD></HEAD><BODY><P>You can use Above()/Below() functions to do this</P><P><A href="https://community.qlik.com/docs/DOC-8242">Missing Manual - Above() and Below()</A></P><P></P><P><STRONG>Below([CostUmers CY])</STRONG></P></BODY></HTML> Tue, 14 Mar 2017 16:41:48 GMT https://community.qlik.com/t5/QlikView/Comparison-previous-year-in-case-date-is-a-dimension/m-p/1288184#M849251 sunny_talwar 2017-03-14T16:41:48Z