topic Re: Comparing two years sales without set analysis in QlikView https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564826#M1118015 <HTML><HEAD></HEAD><BODY><P>In script you create a calendar with the desired time ranges in a field to include as a dimension in your charts. Here you can find how to do that:</P><P><A href="http://qlikviewnotes.blogspot.nl/2012/01/easy-period-analysis-using-qlikview.html" title="http://qlikviewnotes.blogspot.nl/2012/01/easy-period-analysis-using-qlikview.html">Qlikview Notes: Easy Period Analysis using Qlikview Components</A></P></BODY></HTML> Mon, 10 Feb 2014 11:30:46 GMT stigchel 2014-02-10T11:30:46Z Comparing two years sales without set analysis https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564824#M1118013 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>can any body tell me how to show current year and previous years charts with out set analysis.</P><P></P><P>regards</P><P>Mahesh T</P></BODY></HTML> Mon, 10 Feb 2014 11:13:00 GMT https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564824#M1118013 2014-02-10T11:13:00Z Re: Comparing two years sales without set analysis https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564825#M1118014 <HTML><HEAD></HEAD><BODY><P>sum(if(Year=2014, Sales))</P><P></P><P>sum(if(Year=year(Today())-1, Sales))</P></BODY></HTML> Mon, 10 Feb 2014 11:20:39 GMT https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564825#M1118014 maxgro 2014-02-10T11:20:39Z Re: Comparing two years sales without set analysis https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564826#M1118015 <HTML><HEAD></HEAD><BODY><P>In script you create a calendar with the desired time ranges in a field to include as a dimension in your charts. Here you can find how to do that:</P><P><A href="http://qlikviewnotes.blogspot.nl/2012/01/easy-period-analysis-using-qlikview.html" title="http://qlikviewnotes.blogspot.nl/2012/01/easy-period-analysis-using-qlikview.html">Qlikview Notes: Easy Period Analysis using Qlikview Components</A></P></BODY></HTML> Mon, 10 Feb 2014 11:30:46 GMT https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564826#M1118015 stigchel 2014-02-10T11:30:46Z Re: Comparing two years sales without set analysis https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564827#M1118016 <HTML><HEAD></HEAD><BODY><P>mahesh why dont you want set analysis?</P><P>Do you have any technical reason or advantage of not using the set modifier.</P></BODY></HTML> Mon, 10 Feb 2014 11:33:45 GMT https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564827#M1118016 sujeetsingh 2014-02-10T11:33:45Z Re: Comparing two years sales without set analysis https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564828#M1118017 <HTML><HEAD></HEAD><BODY><P>Hi sujeet,</P><P>it is asked in interview generally i do with set analysis.But he particularly mentioned about that.</P><P></P><P>regards</P><P>Mahesh t</P></BODY></HTML> Mon, 10 Feb 2014 11:40:15 GMT https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564828#M1118017 2014-02-10T11:40:15Z Re: Comparing two years sales without set analysis https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564829#M1118018 <HTML><HEAD></HEAD><BODY><P>ok that is to test the tricks .</P><P>Ok you can use the is satement as one suggested and also use the document function to accomplish that .</P></BODY></HTML> Mon, 10 Feb 2014 11:43:49 GMT https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564829#M1118018 sujeetsingh 2014-02-10T11:43:49Z Re: Comparing two years sales without set analysis https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564830#M1118019 <HTML><HEAD></HEAD><BODY><P>fine Sujjeth .can you please give me solution to suppose for previous year we apply modifier '1' for all selections and '$' for current selections.can we achieve by any other option can you please give me functions too for expressions.</P><P>regards</P><P>Mahesh T</P></BODY></HTML> Mon, 10 Feb 2014 12:00:27 GMT https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564830#M1118019 2014-02-10T12:00:27Z Re: Comparing two years sales without set analysis https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564831#M1118020 <HTML><HEAD></HEAD><BODY><P>You can use Alternate States. It means that some selections will be done on Alternate1, some on Alternate2. So one will get Year Ago, one will get this year.</P><P>Each Chart can be linked to a specific Alternate State.</P><P></P><P>You create the first AS by clicking on Document Properties / general Tab / Alternate States. After that, the AS will be available for ListBox, Chart ...</P><P></P><P>Fabrice</P></BODY></HTML> Mon, 10 Feb 2014 18:10:18 GMT https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564831#M1118020 2014-02-10T18:10:18Z Re: Comparing two years sales without set analysis https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564832#M1118021 <HTML><HEAD></HEAD><BODY><P>fine answer can u elaborate with some example naming in alternate states etc.</P></BODY></HTML> Tue, 11 Feb 2014 14:25:01 GMT https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564832#M1118021 2014-02-11T14:25:01Z Re: Comparing two years sales without set analysis https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564833#M1118022 <HTML><HEAD></HEAD><BODY><P>Sorry, I do not understand what you mean.</P><P>Alternate States are an "out-of-the-box" possibility of QlikView.</P><P></P><P>Look for some docs about it: there are plenty I am sure</P><P></P><P>Fabrice</P></BODY></HTML> Tue, 11 Feb 2014 14:29:18 GMT https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564833#M1118022 2014-02-11T14:29:18Z Re: Comparing two years sales without set analysis https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564834#M1118023 <HTML><HEAD></HEAD><BODY><P>Ok.fine i will check it.i have not used alternate sates yet.i am closing the thread.</P><P></P><P>regards</P><P>Mahesh T</P></BODY></HTML> Tue, 11 Feb 2014 14:33:49 GMT https://community.qlik.com/t5/QlikView/Comparing-two-years-sales-without-set-analysis/m-p/564834#M1118023 2014-02-11T14:33:49Z