topic HELP! - Set Analysis in QlikView https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290018#M107638 <HTML><HEAD></HEAD><BODY><P>solved already. thanks</P></BODY></HTML> Wed, 02 Nov 2011 08:10:41 GMT 2011-11-02T08:10:41Z HELP! - Set Analysis https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290017#M107637 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>My financial year starts from April till March.</P><P>I would like to calculate Feb YTD 2011 which means total amount from April until Feb 2011</P><P></P><P>Issue: WHen I select MonthName - Feb, my formula only show the amount for Feb. It should sum up from April until Feb.</P><P>The weird thing is when I select MonthID, it works perfectly</P><P><BR />HOw to make it works by selecting MonthName?</P><P></P><P>I have attached the sample</P></BODY></HTML> Wed, 02 Nov 2011 07:23:50 GMT https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290017#M107637 2011-11-02T07:23:50Z HELP! - Set Analysis https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290018#M107638 <HTML><HEAD></HEAD><BODY><P>solved already. thanks</P></BODY></HTML> Wed, 02 Nov 2011 08:10:41 GMT https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290018#M107638 2011-11-02T08:10:41Z Re: HELP! - Set Analysis https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290019#M107639 <HTML><HEAD></HEAD><BODY><P>Please, check the attachement.</P><P></P><P>Kiran.</P></BODY></HTML> Wed, 02 Nov 2011 08:14:48 GMT https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290019#M107639 2011-11-02T08:14:48Z Re: HELP! - Set Analysis https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290020#M107640 <HTML><HEAD></HEAD><BODY><P>Just wonder why we need to put blank parameter since MonthID will link to MonthName &amp; vice versa?</P></BODY></HTML> Wed, 02 Nov 2011 08:58:57 GMT https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290020#M107640 2011-11-02T08:58:57Z Re: HELP! - Set Analysis https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290021#M107641 <HTML><HEAD></HEAD><BODY><P>First of all did this work for you? </P><P></P><P>If you are just running without MonthName, $ forces set on available data set. Since the computation involves outside the selection block we need to consider the field on which selection is made.</P><P></P><P>Kiran.</P></BODY></HTML> Wed, 02 Nov 2011 09:09:46 GMT https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290021#M107641 2011-11-02T09:09:46Z Re: HELP! - Set Analysis https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290022#M107642 <HTML><HEAD></HEAD><BODY><P>yes, it works!</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 02 Nov 2011 09:11:20 GMT https://community.qlik.com/t5/QlikView/HELP-Set-Analysis/m-p/290022#M107642 2011-11-02T09:11:20Z