topic Re: Last 12 Month complete data set in QlikView https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645396#M236503 <HTML><HEAD></HEAD><BODY><P>Attached with answer.</P><P></P><P>I created an input box, where you can enter the date from which you wanna calculate 12 months back. So in this case if you enter 2/1/2014 then it would give you the desired result in the table below that.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 24 Jul 2014 16:43:48 GMT 2014-07-24T16:43:48Z Last 12 Month complete data set https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645395#M236502 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>I want to show the last 12 Month sales for thos id which have sales entry in each month.</P><P></P><P>Please find the attached excel.</P><P></P><P>Expected results are as,</P><P>e:g</P><P>If you select month 01-02-2014,</P><P>step-1 : Check how many contract have sales for that month. c1,c2,c3,c4,c5</P><P>step-2 : How many contract from step-1 have entry for last 12 month. There should be one entry for all last month which from 01-02-2014 to 01-03-2013, contract are c1 &amp; c2.</P><P>c3 is missing in 01-10-2013</P><P>c4 is missing in 01-12-2013</P><P>c5 is missing in 01-08-2013</P><P></P><P>Final sum would be sum of c1 &amp; c2 for the period 01-03-2014 to 01-02-2014 is 228.</P><P></P><P>I want to do in UI.</P><P></P><P>can anyone help me get the expression for the above scenario?</P></BODY></HTML> Thu, 24 Jul 2014 12:56:42 GMT https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645395#M236502 qliksus 2014-07-24T12:56:42Z Re: Last 12 Month complete data set https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645396#M236503 <HTML><HEAD></HEAD><BODY><P>Attached with answer.</P><P></P><P>I created an input box, where you can enter the date from which you wanna calculate 12 months back. So in this case if you enter 2/1/2014 then it would give you the desired result in the table below that.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 24 Jul 2014 16:43:48 GMT https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645396#M236503 2014-07-24T16:43:48Z Re: Last 12 Month complete data set https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645397#M236504 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You forgot include the attachment</P></BODY></HTML> Thu, 24 Jul 2014 20:35:42 GMT https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645397#M236504 qliksus 2014-07-24T20:35:42Z Re: Re: Last 12 Month complete data set https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645398#M236505 <HTML><HEAD></HEAD><BODY><P>Its attached. Some people are not able to view attachments, dont know why. Let me try re-attaching it.</P><P>Let me know if you can see it.</P><P></P><P>Thanks</P></BODY></HTML> Thu, 24 Jul 2014 20:39:08 GMT https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645398#M236505 2014-07-24T20:39:08Z Re: Last 12 Month complete data set https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645399#M236506 <HTML><HEAD></HEAD><BODY><P>Hi Ajay,</P><P>still i can't find the attachement.Can you please paste expression you have writen?</P></BODY></HTML> Thu, 24 Jul 2014 20:48:18 GMT https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645399#M236506 qliksus 2014-07-24T20:48:18Z Re: Last 12 Month complete data set https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645400#M236507 <HTML><HEAD></HEAD><BODY><P>Its a trigger. <A href="https://community.qlik.com/qlik-users/59295">Sara Leslie</A> people are not able to see my attachment. I faced this issue a while back. It seems to happen sporadically. Do you know why? </P></BODY></HTML> Thu, 24 Jul 2014 20:53:50 GMT https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645400#M236507 2014-07-24T20:53:50Z Re: Last 12 Month complete data set https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645401#M236508 <HTML><HEAD></HEAD><BODY><P>Hi Ajay,</P><P>Can you please copy the code ?</P><P></P><P>Thanks,</P><P>Susant</P></BODY></HTML> Fri, 25 Jul 2014 20:25:22 GMT https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645401#M236508 qliksus 2014-07-25T20:25:22Z Re: Last 12 Month complete data set https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645402#M236509 <HTML><HEAD></HEAD><BODY><P>Its kinda tough to explain. Can I have your email id. I can send the qvw.</P></BODY></HTML> Fri, 25 Jul 2014 20:31:03 GMT https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645402#M236509 2014-07-25T20:31:03Z Re: Last 12 Month complete data set https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645403#M236510 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P><A class="jive-link-email-small" href="mailto:sus_335@yahoo.co.in">sus_335@yahoo.co.in</A></P></BODY></HTML> Fri, 25 Jul 2014 23:59:37 GMT https://community.qlik.com/t5/QlikView/Last-12-Month-complete-data-set/m-p/645403#M236510 qliksus 2014-07-25T23:59:37Z