topic Re: I need expression for Current Financial Year vs Previous Financial Year in bar chart in QlikView https://community.qlik.com/t5/QlikView/I-need-expression-for-Current-Financial-Year-vs-Previous/m-p/714869#M257236 <HTML><HEAD></HEAD><BODY><P>You can assign a variable wich takes value as getcurrentselected Year or by default maxYear</P><P>Now you need to use two expression one with set analysis of current year and one with set analysis with curent year -1</P></BODY></HTML> Fri, 05 Sep 2014 06:02:19 GMT sujeetsingh 2014-09-05T06:02:19Z I need expression for Current Financial Year vs Previous Financial Year in bar chart https://community.qlik.com/t5/QlikView/I-need-expression-for-Current-Financial-Year-vs-Previous/m-p/714867#M257234 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 12px; background-color: #f6f6f6;">Can you tell expression for Current Financial Year vs Previous Financial Year expressions in Barchart?</SPAN></P></BODY></HTML> Fri, 05 Sep 2014 05:56:05 GMT https://community.qlik.com/t5/QlikView/I-need-expression-for-Current-Financial-Year-vs-Previous/m-p/714867#M257234 balasundaram 2014-09-05T05:56:05Z Re: I need expression for Current Financial Year vs Previous Financial Year in bar chart https://community.qlik.com/t5/QlikView/I-need-expression-for-Current-Financial-Year-vs-Previous/m-p/714868#M257235 <HTML><HEAD></HEAD><BODY><P>See: <A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd" title="http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd">Year Over Year Comparison</A> </P></BODY></HTML> Fri, 05 Sep 2014 06:00:25 GMT https://community.qlik.com/t5/QlikView/I-need-expression-for-Current-Financial-Year-vs-Previous/m-p/714868#M257235 tresB 2014-09-05T06:00:25Z Re: I need expression for Current Financial Year vs Previous Financial Year in bar chart https://community.qlik.com/t5/QlikView/I-need-expression-for-Current-Financial-Year-vs-Previous/m-p/714869#M257236 <HTML><HEAD></HEAD><BODY><P>You can assign a variable wich takes value as getcurrentselected Year or by default maxYear</P><P>Now you need to use two expression one with set analysis of current year and one with set analysis with curent year -1</P></BODY></HTML> Fri, 05 Sep 2014 06:02:19 GMT https://community.qlik.com/t5/QlikView/I-need-expression-for-Current-Financial-Year-vs-Previous/m-p/714869#M257236 sujeetsingh 2014-09-05T06:02:19Z Re: I need expression for Current Financial Year vs Previous Financial Year in bar chart https://community.qlik.com/t5/QlikView/I-need-expression-for-Current-Financial-Year-vs-Previous/m-p/714870#M257237 <HTML><HEAD></HEAD><BODY><P>Dear Balasun,</P><P></P><P>Kindly, find attached document.</P><P></P><P></P><P>Kind regards,</P><P>Ishfaque Ahmed</P></BODY></HTML> Fri, 05 Sep 2014 06:27:14 GMT https://community.qlik.com/t5/QlikView/I-need-expression-for-Current-Financial-Year-vs-Previous/m-p/714870#M257237 engishfaque 2014-09-05T06:27:14Z Re: I need expression for Current Financial Year vs Previous Financial Year in bar chart https://community.qlik.com/t5/QlikView/I-need-expression-for-Current-Financial-Year-vs-Previous/m-p/714871#M257238 <HTML><HEAD></HEAD><BODY><P>Dimension=Year</P><P><BR />Expression</P><P>=Sum({$ &lt;Year = {Year(today()), Year(today())-1}&gt; }Sales)</P><P><BR />I hvnt tested but it shall work</P></BODY></HTML> Fri, 05 Sep 2014 06:36:31 GMT https://community.qlik.com/t5/QlikView/I-need-expression-for-Current-Financial-Year-vs-Previous/m-p/714871#M257238 2014-09-05T06:36:31Z