Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

Set Analysis - Division issue

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:

TestFY 2019 – VALIDATED FY 2019 – ACTUALFY 2019 – VALIDATED vs ACTUAL
Data277.80286.71434.37

 

Numerator   
TestFY 2019 – VALIDATED FY 2019 – ACTUALFY 2019 – VALIDATED vs ACTUAL
Data-12,040,369,761.54-13,176,043,339.571,135,673,578.03

 

Denominator   
TestFY 2019 – VALIDATED FY 2019 – ACTUALFY 2019 – VALIDATED vs ACTUAL
Data43,341,367.2145,955,869.51-2,614,502.30

 

Expected Result   
TestFY 2019 – VALIDATED FY 2019 – ACTUALFY 2019 – VALIDATED vs ACTUAL
Data277.80286.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.

Labels (1)