Hello,
I'm new to QlikSense and I'm trying to achieve the expected result with set analysis. but I'm unable to. could you please help me on this.
Sample:
Measure:
Num(
Fabs(
(Sum({$<Year=, [Month Year]=>} Field1*Flag)
- Sum({$<Year=, [Month Year]=>} Field2*Flag))
/
(Sum({$<Year=, [Month Year]=>}Field3*Flag)
+ Sum({$<Year=, [Month Year]=>}Field4*Flag))
)))
Actual Result:
| Test | FY 2019 – VALIDATED | FY 2019 – ACTUAL | FY 2019 – VALIDATED vs ACTUAL |
| Data | 277.80 | 286.71 | 434.37 |
| Numerator | | | |
| Test | FY 2019 – VALIDATED | FY 2019 – ACTUAL | FY 2019 – VALIDATED vs ACTUAL |
| Data | -12,040,369,761.54 | -13,176,043,339.57 | 1,135,673,578.03 |
| Denominator | | | |
| Test | FY 2019 – VALIDATED | FY 2019 – ACTUAL | FY 2019 – VALIDATED vs ACTUAL |
| Data | 43,341,367.21 | 45,955,869.51 | -2,614,502.30 |
| Expected Result | | | |
| Test | FY 2019 – VALIDATED | FY 2019 – ACTUAL | FY 2019 – VALIDATED vs ACTUAL |
| Data | 277.80 | 286.71 | -8.91 |
The value in 'FY 2019 – VALIDATED vs ACTUAL' should work with Flag used, not with the division.
attached sample data for reference. Please help me with the suitable expression.
Thanks a lot in advance.
