topic Period comparison in QlikView https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566046#M211163 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P>my Location is Germany and I am a relatively new QV - Developer.</P><P></P><P>My next Task: Make comparisons of Dates/Periods, i.e. Years, Month, Quarter, Week (Last Period, Last Years Period).</P><P></P><P>I am convinced that there are a lot of possibilities, however, I am still searching for BEST PRACTICE.</P><P></P><P>May I ask the community to give me some workable procedures? Thanks a lot!</P><P></P><P>Wolfgang</P></BODY></HTML> Mon, 28 Apr 2014 08:00:13 GMT Anonymous 2014-04-28T08:00:13Z Period comparison https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566046#M211163 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P>my Location is Germany and I am a relatively new QV - Developer.</P><P></P><P>My next Task: Make comparisons of Dates/Periods, i.e. Years, Month, Quarter, Week (Last Period, Last Years Period).</P><P></P><P>I am convinced that there are a lot of possibilities, however, I am still searching for BEST PRACTICE.</P><P></P><P>May I ask the community to give me some workable procedures? Thanks a lot!</P><P></P><P>Wolfgang</P></BODY></HTML> Mon, 28 Apr 2014 08:00:13 GMT https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566046#M211163 Anonymous 2014-04-28T08:00:13Z Re: Period comparison https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566047#M211164 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can create variables like year=max(Year),previous year=max(year)-1 like this for month and week also</P><P>and then you can compare periods</P><P>Hope this will help you</P><P>Regards,</P><P>Vijeta</P></BODY></HTML> Mon, 28 Apr 2014 08:04:00 GMT https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566047#M211164 vijetas42 2014-04-28T08:04:00Z Re: Period comparison https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566048#M211165 <HTML><HEAD></HEAD><BODY><P>Wolfgang,</P><P></P><P>did you tryed to search here?</P><P>There are different ways to do period comparisions and you should choose one which will be the best for application, you create.</P><P>For the begining you may try Tools/Time Chart Wizard.</P><P></P><P>regards</P><P>Darek</P></BODY></HTML> Mon, 28 Apr 2014 08:05:18 GMT https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566048#M211165 2014-04-28T08:05:18Z Re: Period comparison https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566049#M211166 <HTML><HEAD></HEAD><BODY><P>Best practise would be to create a Master Calendar which flags Last Year, Last Years Period etc.</P><P></P><P>Fortunately, there are a lot of documents &amp; forum post on that topic in this community.</P></BODY></HTML> Mon, 28 Apr 2014 08:07:10 GMT https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566049#M211166 simondachstr 2014-04-28T08:07:10Z Re: Period comparison https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566050#M211167 <HTML><HEAD></HEAD><BODY><P>I recommend reading blogs by HIC , like:</P><UL><LI><A href="http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right" title="http://community.qlik.com/blogs/qlikviewdesignblog/2012/06/07/get-the-dates-right">QlikView Design Blog : Get the Dates Right | Qlik Community</A></LI><LI><A href="http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year" title="http://community.qlik.com/blogs/qlikviewdesignblog/2013/05/28/fiscal-year">QlikView Design Blog : Fiscal Year | Qlik Community</A></LI></UL></BODY></HTML> Mon, 28 Apr 2014 08:07:23 GMT https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566050#M211167 tresB 2014-04-28T08:07:23Z Re: Period comparison https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566051#M211168 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can also see the blogs or links</P><P><A _jive_internal="true" href="https://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd">http://community.qlik.com/blogs/qlikviewdesignblog/2014/03/03/ytd</A></P><P><A _jive_internal="true" href="https://community.qlik.com/message/461745#461745">http://community.qlik.com/message/461745#461745</A></P><P>Regards,</P><P>Vijeta</P></BODY></HTML> Mon, 28 Apr 2014 08:11:33 GMT https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566051#M211168 vijetas42 2014-04-28T08:11:33Z Re: Re: Period comparison https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566052#M211169 <HTML><HEAD></HEAD><BODY><P>Dear ,</P><P></P><P></P><P>Kindly find the attachment.</P><P></P><P>i hope it will help you.</P><P></P><P>Thanks,</P><P>Mukram.</P></BODY></HTML> Mon, 28 Apr 2014 08:12:39 GMT https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566052#M211169 mdmukramali 2014-04-28T08:12:39Z Re: Period comparison https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566053#M211170 <HTML><HEAD></HEAD><BODY><P>Read this documents for period combinations</P><P></P><P><A href="https://community.qlik.com/docs/DOC-4313">QlikView App: Set Analysis - Prior Period Comparison</A></P></BODY></HTML> Mon, 28 Apr 2014 08:27:10 GMT https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566053#M211170 its_anandrjs 2014-04-28T08:27:10Z Re: Period comparison https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566054#M211171 <HTML><HEAD></HEAD><BODY><P><A href="https://community.qlik.com/thread/115737">compare current year previous year</A></P><P></P><P><STRONG>Read Steve Dark's Reply </STRONG></P></BODY></HTML> Mon, 28 Apr 2014 08:45:41 GMT https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566054#M211171 MK_QSL 2014-04-28T08:45:41Z Re: Period comparison https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566055#M211172 <HTML><HEAD></HEAD><BODY><P>Thanks to all of you, I am on a very good way, thanks to your Input!</P><P>Wolfgang</P></BODY></HTML> Mon, 05 May 2014 07:59:11 GMT https://community.qlik.com/t5/QlikView/Period-comparison/m-p/566055#M211172 Anonymous 2014-05-05T07:59:11Z