topic Re: what's wrong with this formula... in QlikView https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380224#M141823 <HTML><HEAD></HEAD><BODY><P>Hi Srinivas,</P><P></P><P>Thanks for your reply, but still it's not working.</P><P>am attaching my solution file for the reference,please need your help.</P><P></P><P>Thanks,</P><P>Venkat T</P></BODY></HTML> Thu, 23 Aug 2012 04:30:58 GMT 2012-08-23T04:30:58Z what's wrong with this formula... https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380222#M141821 <HTML><HEAD></HEAD><BODY><P>Hello All,</P><P></P><P>am sorry if am asking the basic thing, but this formula doesn't seem to be working..</P><P></P><P>=sum({$&lt;[Qtr-Num]={$(#vLastQtr)}&gt;}Total)</P><P></P><P>vLastQrt is a Variable where it picks the prev quarter from the current selection.</P><P></P><P>Please need some one's help here urgently..</P><P></P><P></P><P>Thanks &amp; Regards,</P><P>Venkat T</P></BODY></HTML> Thu, 23 Aug 2012 03:54:33 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380222#M141821 2012-08-23T03:54:33Z Re: what's wrong with this formula... https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380223#M141822 <HTML><HEAD></HEAD><BODY><P>Try this</P><P>=sum({$&lt;[Qtr-Num]={=$(Only([Qtr-Num])-1)}&gt;}Total)</P></BODY></HTML> Thu, 23 Aug 2012 04:01:11 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380223#M141822 sreenivas 2012-08-23T04:01:11Z Re: what's wrong with this formula... https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380224#M141823 <HTML><HEAD></HEAD><BODY><P>Hi Srinivas,</P><P></P><P>Thanks for your reply, but still it's not working.</P><P>am attaching my solution file for the reference,please need your help.</P><P></P><P>Thanks,</P><P>Venkat T</P></BODY></HTML> Thu, 23 Aug 2012 04:30:58 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380224#M141823 2012-08-23T04:30:58Z Re: what's wrong with this formula... https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380225#M141824 <HTML><HEAD></HEAD><BODY><P>Please find the attachment</P></BODY></HTML> Thu, 23 Aug 2012 04:42:54 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380225#M141824 sreenivas 2012-08-23T04:42:54Z Re: what's wrong with this formula... https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380226#M141825 <HTML><HEAD></HEAD><BODY><P>Hi Srinivas,</P><P></P><P>Thanks for your help, this works with Quarter-Num selections, but i cant have Quarter-Num list box in my solution.i have to manage this to work with Quarter selection or it would be great if it can be acheived with Quarter it self(as it is in the text format am not able to perform the math operations)...</P><P></P><P>Quarter-Num and Quarter are interlinked(Quarter-Num is nothing but gives the num of quarter what we have in the data in desc order)</P><P></P><P>Hope you understand my situation.Please need more suggestions.</P><P></P><P>Thanks ,</P><P>Venkat T</P></BODY></HTML> Thu, 23 Aug 2012 04:59:27 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380226#M141825 2012-08-23T04:59:27Z Re: what's wrong with this formula... https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380227#M141826 <HTML><HEAD></HEAD><BODY><P>Try This may help you on click of quarter</P><P></P><P>=Sum({$&lt;Quarter=,[Qtr-Num]={$(=Only([Qtr-Num])-1)}&gt;} Total)</P></BODY></HTML> Thu, 23 Aug 2012 05:17:08 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380227#M141826 sreenivas 2012-08-23T05:17:08Z Re: what's wrong with this formula... https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380228#M141827 <HTML><HEAD></HEAD><BODY><P>Hey Sreenivas that works, thankyou so much for your help...</P><P></P><P>Thanks &amp; Regards,</P><P>Venkat T</P></BODY></HTML> Thu, 23 Aug 2012 08:10:10 GMT https://community.qlik.com/t5/QlikView/what-s-wrong-with-this-formula/m-p/380228#M141827 2012-08-23T08:10:10Z