topic Re: Comparison Sales with period in QlikView https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635943#M233238 <HTML><HEAD></HEAD><BODY><P>Did you attached a file ?</P><P>I don't find it.</P></BODY></HTML> Fri, 16 May 2014 13:22:33 GMT geogou1973 2014-05-16T13:22:33Z Comparison Sales with period https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635941#M233236 <HTML><HEAD></HEAD><BODY><P>Hello.</P><P></P><P>Can anyone tell me how to summarize the sales of the 2014 of May and the corresponding period of May 2013.</P><P>eg. 1-16/05/2013 and 1-6-/05/2014 in two expression columns Current Sales and Previous Sales by selecting the years and the month</P><P>Any help ?</P><P></P><P>Thank you in advance.</P></BODY></HTML> Fri, 16 May 2014 12:59:20 GMT https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635941#M233236 geogou1973 2014-05-16T12:59:20Z Re: Comparison Sales with period https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635942#M233237 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Please find attached example.</P><P>Hope this helps.</P><P></P><P>Andrei</P></BODY></HTML> Fri, 16 May 2014 13:20:32 GMT https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635942#M233237 crusader_ 2014-05-16T13:20:32Z Re: Comparison Sales with period https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635943#M233238 <HTML><HEAD></HEAD><BODY><P>Did you attached a file ?</P><P>I don't find it.</P></BODY></HTML> Fri, 16 May 2014 13:22:33 GMT https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635943#M233238 geogou1973 2014-05-16T13:22:33Z Re: Comparison Sales with period https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635944#M233239 <HTML><HEAD></HEAD><BODY><P>Check again</P><P></P><P>Andrei</P></BODY></HTML> Fri, 16 May 2014 13:24:42 GMT https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635944#M233239 crusader_ 2014-05-16T13:24:42Z Re: Comparison Sales with period https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635945#M233240 <HTML><HEAD></HEAD><BODY><P>i didn't refresh. Sorry.</P></BODY></HTML> Fri, 16 May 2014 13:25:13 GMT https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635945#M233240 geogou1973 2014-05-16T13:25:13Z Re: Comparison Sales with period https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635946#M233241 <HTML><HEAD></HEAD><BODY><P>Andrei this does not work at all.</P><P></P><P>We have all the sales by day of May 2013.</P><P>We have also the sales of 1-15 May 2014.</P><P>How can i compare by clicking only the two years 2013 - 2014 and the month the two periods 1-15 May 2013 and</P><P>1-15 May 2014 in a chart by set analysis</P></BODY></HTML> Fri, 16 May 2014 13:36:22 GMT https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635946#M233241 geogou1973 2014-05-16T13:36:22Z Re: Comparison Sales with period https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635947#M233242 <HTML><HEAD></HEAD><BODY><P>If you built your Master calendar properly,then this should work automatically.</P><P>and you can use the Currentyear and lastyear flags</P></BODY></HTML> Fri, 16 May 2014 13:40:53 GMT https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635947#M233242 Anonymous 2014-05-16T13:40:53Z Re: Comparison Sales with period https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635948#M233243 <HTML><HEAD></HEAD><BODY><P>The fields i have are </P><P>YEAR_ID</P><P>MONTH_ID</P><P>DATE_ID</P><P>STORE_ID</P><P>ITEM_ID</P><P>SALES</P><P>QTY</P><P></P><P>and i collect the data into a qvd by month.</P><P>What do you mean to built my Calendar properly ?</P></BODY></HTML> Fri, 16 May 2014 13:46:55 GMT https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635948#M233243 geogou1973 2014-05-16T13:46:55Z Re: Comparison Sales with period https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635949#M233244 <HTML><HEAD></HEAD><BODY><P>Hm... You should add in Set Analysis expression days or intervals (1-15). Smth like that:</P><P></P><P>=sum({$&lt;Year={$(=Year)},Day={"&lt;=15"}&gt;}Sales) - first expression</P><P>=sum({$&lt;Year={$(=Year-1)},Day={"&lt;=15"}&gt;}Sales) - second expression</P><P></P><P>Anyway you should consider your days in Set Analysis.</P><P></P><P>Andrei</P></BODY></HTML> Fri, 16 May 2014 13:47:08 GMT https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635949#M233244 crusader_ 2014-05-16T13:47:08Z Re: Comparison Sales with period https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635950#M233245 <HTML><HEAD></HEAD><BODY><P>Check this very useful blogpost</P><P>community.qlik.com/blogs/qlikviewdesignblog/2012/10/16/the-master-calendar</P><P></P><P>Andrei</P></BODY></HTML> Fri, 16 May 2014 13:49:14 GMT https://community.qlik.com/t5/QlikView/Comparison-Sales-with-period/m-p/635950#M233245 crusader_ 2014-05-16T13:49:14Z