topic Re: Qlik View to Qlik Sense Conversion - Missing "Full Accumulation" and "Relative&qu in App Development

Qlik View to Qlik Sense Conversion - Missing "Full Accumulation" and "Relative" for expressions

FMDF — Sat, 16 Nov 2024 18:43:15 GMT

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.

Re: Qlik View to Qlik Sense Conversion - Missing "Full Accumulation" and "Relative&qu

Lisa_P — Tue, 28 Apr 2020 23:07:39 GMT

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

Re: Qlik View to Qlik Sense Conversion - Missing "Full Accumulation" and "Relative&am

FMDF — Thu, 30 Apr 2020 19:18:47 GMT

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.

Re: Qlik View to Qlik Sense Conversion - Missing "Full Accumulation" and "Relative&am

FMDF — Thu, 30 Apr 2020 19:44:55 GMT

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.