topic Comparative Analysis in QlikView https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/104396#M16455 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am comparing a two periods and am trying to get an apples to apples comparison.&nbsp; In my comparison, I only want the results for a DRG Group be compared if there is both Volume in both Periods.&nbsp; What is occuring right now, is if I filter by a Hospital (or Other Filters) and cycle through different Dimensions, I get somewhat different result, as the results when Cycled by the Hospital appear to be counting everything regardless of a 1-to-1 match and the Cycle by DRG Group appears to be excluding these from the results.&nbsp; If someone can provide feedback on adjusting the formula, it would be greatly appreciated.&nbsp; Formula change would be for Expressions Starting MCC &amp; CC %, Ending MCC &amp; CC %, Change MCC &amp; CC %, Starting CMI, Ending CMI adn CMI Change %.&nbsp; I have attached a copy of the Qlikview File</P></BODY></HTML> Mon, 24 Sep 2018 18:09:12 GMT bxprokop 2018-09-24T18:09:12Z Comparative Analysis https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/104396#M16455 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I am comparing a two periods and am trying to get an apples to apples comparison.&nbsp; In my comparison, I only want the results for a DRG Group be compared if there is both Volume in both Periods.&nbsp; What is occuring right now, is if I filter by a Hospital (or Other Filters) and cycle through different Dimensions, I get somewhat different result, as the results when Cycled by the Hospital appear to be counting everything regardless of a 1-to-1 match and the Cycle by DRG Group appears to be excluding these from the results.&nbsp; If someone can provide feedback on adjusting the formula, it would be greatly appreciated.&nbsp; Formula change would be for Expressions Starting MCC &amp; CC %, Ending MCC &amp; CC %, Change MCC &amp; CC %, Starting CMI, Ending CMI adn CMI Change %.&nbsp; I have attached a copy of the Qlikview File</P></BODY></HTML> Mon, 24 Sep 2018 18:09:12 GMT https://community.qlik.com/t5/QlikView/Comparative-Analysis/m-p/104396#M16455 bxprokop 2018-09-24T18:09:12Z