topic How can write set analysis expression which analysis sales for sales up to this year and sales up to this point last year? in QlikView https://community.qlik.com/t5/QlikView/How-can-write-set-analysis-expression-which-analysis-sales-for/m-p/925148#M320169 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>How can write set analysis expression which analysis sales for sales up to this year and sales up to this point last year?</P><P></P><P>I have two fields, OrderDate which has all the dates for all the years (including this year and last year)</P><P></P><P>and my Sales field has the sales values.</P><P></P><P>How can I write set analysis which analyses like for like sales this year and last year.</P><P></P><P>It will be a Line Chart with the Dimension as Month (which is coming from the OrderDate field)</P></BODY></HTML> Wed, 23 Sep 2015 14:24:27 GMT jblomqvist 2015-09-23T14:24:27Z How can write set analysis expression which analysis sales for sales up to this year and sales up to this point last year? https://community.qlik.com/t5/QlikView/How-can-write-set-analysis-expression-which-analysis-sales-for/m-p/925148#M320169 <HTML><HEAD></HEAD><BODY><P>Hello,</P><P></P><P>How can write set analysis expression which analysis sales for sales up to this year and sales up to this point last year?</P><P></P><P>I have two fields, OrderDate which has all the dates for all the years (including this year and last year)</P><P></P><P>and my Sales field has the sales values.</P><P></P><P>How can I write set analysis which analyses like for like sales this year and last year.</P><P></P><P>It will be a Line Chart with the Dimension as Month (which is coming from the OrderDate field)</P></BODY></HTML> Wed, 23 Sep 2015 14:24:27 GMT https://community.qlik.com/t5/QlikView/How-can-write-set-analysis-expression-which-analysis-sales-for/m-p/925148#M320169 jblomqvist 2015-09-23T14:24:27Z Re: How can write set analysis expression which analysis sales for sales up to this year and sales up to this point last year? https://community.qlik.com/t5/QlikView/How-can-write-set-analysis-expression-which-analysis-sales-for/m-p/925149#M320170 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/docs/DOC-9144">Set Analysis for Rolling Periods</A></P></BODY></HTML> Wed, 23 Sep 2015 14:28:03 GMT https://community.qlik.com/t5/QlikView/How-can-write-set-analysis-expression-which-analysis-sales-for/m-p/925149#M320170 giakoum 2015-09-23T14:28:03Z