Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor II

Comparative Analysis

Hi,

I am comparing a two periods and am trying to get an apples to apples comparison.  In my comparison, I only want the results for a DRG Group be compared if there is both Volume in both Periods.  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.  If someone can provide feedback on adjusting the formula, it would be greatly appreciated.  Formula change would be for Expressions Starting MCC & CC %, Ending MCC & CC %, Change MCC & CC %, Starting CMI, Ending CMI adn CMI Change %.  I have attached a copy of the Qlikview File