topic Re. :Small Query on Set Analysis in QlikView https://community.qlik.com/t5/QlikView/Small-Query-on-Set-Analysis/m-p/257474#M1205146 <HTML><HEAD></HEAD><BODY><P>saved my day <IMG alt="Embarrassed" src="http://community.qlik.com/emoticons/emotion-10.gif" /></P></BODY></HTML> Fri, 14 May 2010 09:54:32 GMT 2010-05-14T09:54:32Z Small Query on Set Analysis https://community.qlik.com/t5/QlikView/Small-Query-on-Set-Analysis/m-p/257470#M1205142 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a very simple query on Set Analysis. Pls have a look at the attached QV file. What I want to do in a chrt is that when I select a Quarter the first charts shows the data for the quarter and the second shows the data for the previous quarter.</P><P>When I do the same for Years the charts work, but somehow for the quarters they don't work.</P><P></P><P>Help much appreciated thanks</P></BODY></HTML> Fri, 14 May 2010 09:07:56 GMT https://community.qlik.com/t5/QlikView/Small-Query-on-Set-Analysis/m-p/257470#M1205142 2010-05-14T09:07:56Z Small Query on Set Analysis https://community.qlik.com/t5/QlikView/Small-Query-on-Set-Analysis/m-p/257471#M1205143 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can not do this same with year because quarteryear field is not numeric.</P></BODY></HTML> Fri, 14 May 2010 09:21:35 GMT https://community.qlik.com/t5/QlikView/Small-Query-on-Set-Analysis/m-p/257471#M1205143 2010-05-14T09:21:35Z Re. :Small Query on Set Analysis https://community.qlik.com/t5/QlikView/Small-Query-on-Set-Analysis/m-p/257472#M1205144 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>You can not make a substraction on your QuarterYear field, it is necessary to decompose your text field.</P><P>look the attached QV file.</P><P>Regards,</P><P>Martin</P></BODY></HTML> Fri, 14 May 2010 09:33:07 GMT https://community.qlik.com/t5/QlikView/Small-Query-on-Set-Analysis/m-p/257472#M1205144 martin59 2010-05-14T09:33:07Z Re. :Small Query on Set Analysis https://community.qlik.com/t5/QlikView/Small-Query-on-Set-Analysis/m-p/257473#M1205145 <HTML><HEAD></HEAD><BODY><P>thanks Martin you saved by day</P></BODY></HTML> Fri, 14 May 2010 09:50:53 GMT https://community.qlik.com/t5/QlikView/Small-Query-on-Set-Analysis/m-p/257473#M1205145 2010-05-14T09:50:53Z Re. :Small Query on Set Analysis https://community.qlik.com/t5/QlikView/Small-Query-on-Set-Analysis/m-p/257474#M1205146 <HTML><HEAD></HEAD><BODY><P>saved my day <IMG alt="Embarrassed" src="http://community.qlik.com/emoticons/emotion-10.gif" /></P></BODY></HTML> Fri, 14 May 2010 09:54:32 GMT https://community.qlik.com/t5/QlikView/Small-Query-on-Set-Analysis/m-p/257474#M1205146 2010-05-14T09:54:32Z