topic What are different Comparative Analysis formula? in QlikView https://community.qlik.com/t5/QlikView/What-are-different-Comparative-Analysis-formula/m-p/392689#M490402 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have problem on setting up formulas for comparative analysis? Anyone can help me? Please let me know how to get the following...</P><P></P><UL><LI>Year-to-date vs. Last-Year-to-Date</LI><LI>Month-to-date vs. Last-Month-to-date</LI><LI>This Year vs. Last Year</LI><LI>This Month vs. Last Month</LI></UL><P></P><P>Thanks,</P><P>Bill</P></BODY></HTML> Tue, 09 Oct 2012 07:31:24 GMT 2012-10-09T07:31:24Z What are different Comparative Analysis formula? https://community.qlik.com/t5/QlikView/What-are-different-Comparative-Analysis-formula/m-p/392689#M490402 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have problem on setting up formulas for comparative analysis? Anyone can help me? Please let me know how to get the following...</P><P></P><UL><LI>Year-to-date vs. Last-Year-to-Date</LI><LI>Month-to-date vs. Last-Month-to-date</LI><LI>This Year vs. Last Year</LI><LI>This Month vs. Last Month</LI></UL><P></P><P>Thanks,</P><P>Bill</P></BODY></HTML> Tue, 09 Oct 2012 07:31:24 GMT https://community.qlik.com/t5/QlikView/What-are-different-Comparative-Analysis-formula/m-p/392689#M490402 2012-10-09T07:31:24Z Re: What are different Comparative Analysis formula? https://community.qlik.com/t5/QlikView/What-are-different-Comparative-Analysis-formula/m-p/392690#M490403 <HTML><HEAD></HEAD><BODY><P>I'm not sure if this has to be done with comparative analysis.</P><P></P><P>I can imagine that YTD vs last YTD can be done with setanalysis only (by substracting 1 year from the selected year for e.g.)</P><P></P><P>But if you want to do it with comparitive analysis this is possible too. </P><P></P><P>2 questions:</P><P>1: What is the issue you ran into? </P><P>2: And how should it work? (should there be one group of listboxes connected to both states? or 2 groups of listboxes (one for the normal state and one for the alternate state)</P><P></P><P>I'd like to hear</P></BODY></HTML> Tue, 09 Oct 2012 08:56:23 GMT https://community.qlik.com/t5/QlikView/What-are-different-Comparative-Analysis-formula/m-p/392690#M490403 2012-10-09T08:56:23Z Re: What are different Comparative Analysis formula? https://community.qlik.com/t5/QlikView/What-are-different-Comparative-Analysis-formula/m-p/392691#M490404 <HTML><HEAD></HEAD><BODY><P>Using gauges, getting variance (differences)</P></BODY></HTML> Tue, 09 Oct 2012 09:15:45 GMT https://community.qlik.com/t5/QlikView/What-are-different-Comparative-Analysis-formula/m-p/392691#M490404 2012-10-09T09:15:45Z