topic Set analysis: comparison vs last year, simple example in QlikView https://community.qlik.com/t5/QlikView/Set-analysis-comparison-vs-last-year-simple-example/m-p/367636#M1173229 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>It should be very easy, nevertheless I can't get this working. I simply would like to display the correct value in Quarter - 1....</P><P></P><P>Can anybody see my set analysis ? </P><P></P><P>I've attached the qlikview file...</P><P></P><P>Thank you for your help!</P></BODY></HTML> Thu, 24 May 2012 13:35:40 GMT 2012-05-24T13:35:40Z Set analysis: comparison vs last year, simple example https://community.qlik.com/t5/QlikView/Set-analysis-comparison-vs-last-year-simple-example/m-p/367636#M1173229 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>It should be very easy, nevertheless I can't get this working. I simply would like to display the correct value in Quarter - 1....</P><P></P><P>Can anybody see my set analysis ? </P><P></P><P>I've attached the qlikview file...</P><P></P><P>Thank you for your help!</P></BODY></HTML> Thu, 24 May 2012 13:35:40 GMT https://community.qlik.com/t5/QlikView/Set-analysis-comparison-vs-last-year-simple-example/m-p/367636#M1173229 2012-05-24T13:35:40Z Set analysis: comparison vs last year, simple example https://community.qlik.com/t5/QlikView/Set-analysis-comparison-vs-last-year-simple-example/m-p/367637#M1173230 <HTML><HEAD></HEAD><BODY><P>I am not clear on what your exact requirements are but : -</P><P></P><P>=sum({1&lt;[Quarter number]={$(=Only([Quarter number])-1)}&gt;} ZE_value)</P><P></P><P>Will give you Q1 if you have Q2 selected</P></BODY></HTML> Thu, 24 May 2012 13:44:25 GMT https://community.qlik.com/t5/QlikView/Set-analysis-comparison-vs-last-year-simple-example/m-p/367637#M1173230 2012-05-24T13:44:25Z