topic Re: how to calculate in QlikView https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/591475#M478373 <HTML><HEAD></HEAD><BODY><P><A href="http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/" title="http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/">The Magic of Set Analysis – Point In Time Reporting | iQlik - Everything QlikView.</A></P></BODY></HTML> Tue, 18 Mar 2014 22:09:56 GMT swuehl 2014-03-18T22:09:56Z how to calculate https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/591474#M478372 <HTML><HEAD></HEAD><BODY><P>create set analysis for sales ad profits&nbsp; Previous quarter Vs Current Quarter</P></BODY></HTML> Tue, 18 Mar 2014 21:22:30 GMT https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/591474#M478372 2014-03-18T21:22:30Z Re: how to calculate https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/591475#M478373 <HTML><HEAD></HEAD><BODY><P><A href="http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/" title="http://iqlik.wordpress.com/2010/11/27/the-magic-of-set-analysis-point-in-time-reporting/">The Magic of Set Analysis – Point In Time Reporting | iQlik - Everything QlikView.</A></P></BODY></HTML> Tue, 18 Mar 2014 22:09:56 GMT https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/591475#M478373 swuehl 2014-03-18T22:09:56Z Re: how to calculate https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/591476#M478374 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I usually use attached script to create date flags, easy to use and to implement.</P><P></P><P>Create a date_flag table or use parts of the script within your existing table. When you then want to use your flags in the app all you need to do is, Sum({$&lt;_QTD_TY={'1'}&gt;} Sales) and for previous quarter Sum({$&lt;_PR_QTD={'1'}&gt;} Sales) .</P><P></P><P>Sample app: <A href="https://www.dropbox.com/sh/99ktlymtn6ni8py/NEJ0xw8GgJ">https://www.dropbox.com/sh/99ktlymtn6ni8py/NEJ0xw8GgJ</A></P><P></P><P>BR </P><P>Fredrik</P></BODY></HTML> Wed, 19 Mar 2014 09:48:19 GMT https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/591476#M478374 2014-03-19T09:48:19Z Re: how to calculate https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/591477#M478375 <HTML><HEAD></HEAD><BODY><P>Good blog post <A href="https://community.qlik.com/qlik-users/15823">swuehl</A> but if the data-set is large, would i recommend to do some pre-calculations inside the script e.g. date-flags. Set-analysis in combination with large volumes of data can cause heavy cpu loads on the Qlikview-server.</P></BODY></HTML> Thu, 20 Mar 2014 14:30:54 GMT https://community.qlik.com/t5/QlikView/how-to-calculate/m-p/591477#M478375 2014-03-20T14:30:54Z