Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am converting an app from QlikView to Qlik Sense.
I have 3 fields in a table.
All 3 fields have the same expression that can be seen in each of the screen shots.
Image 3 shows that for that field, radio button for Full Accumulation and checkbox for Relative are selected.
Image 4 shows that for that field, radio button for No Accumulation is selected and checkbox for Relative is selected.
I do not see these options in Qlik Sense. I have been searching for solutions but I am not finding anything that clearly explains the work around.
For image 2 - This is the default situation, no settings will need to change
For image 3 - Accumulation is possible since November 2019 release. In the Measure turn on the Modifier>Accumulation and divide the expression by the TOTAL aggregation and format as a percentage.
For image 4 - Divide by the TOTAL aggregation and format as a percentage.
The Total mode is done using Totals function
Thank you for the quick response.
I did what I think you were suggesting but I am not getting the correct results.
Image 3: I did this.
(Sum(GLDistAmount)+ Sum(ProjEventRevAmount)) / (Sum(Total GLDistAmount)+ Sum(Total ProjEventRevAmount))
Set modifier to "Accumulation"
This one is not working.
Image 4: I did this.
(Sum(GLDistAmount)+ Sum(ProjEventRevAmount)) / (Sum(Total GLDistAmount)+ Sum(Total ProjEventRevAmount))
Modifier was none.
This one is working.
I think I am just making an obvious mistake.
I used this formula for scenario 3 and 5.
(Sum(GLDistAmount)+ Sum(ProjEventRevAmount)) / (Sum(Total GLDistAmount)+ Sum(Total ProjEventRevAmount))
Scenario 3 had Modifier "Accumulation and FULL". This one isn't working.
Scenario 4 had no modifier. This one works.