Fabs(), Sum() & Total()

[Anonymous]

Dear community,

I am trying to accumulate percentages in a column for absolute values.

As you can see, the expression in the right column isn't working properly, it seems

like the TOTAL is still the Sum of the values that are not absolute.

Those are my expressions:

Sum({$< [FS Item] = {1180000}>}[Period Value GC])                (left column, values)

fabs(Sum({$< [FS Item] = {1180000}>}[Period Value GC]))       (mid column, absolute values)

Num(fabs(sum({$< [FS Item] = {1180000}>}[Period Value GC])) / fabs(sum({$< [FS Item] = {1180000}>} Total [Period Value GC])), '#,##%')                                                                                    

(right column, where I'd like to get the accumulated percentage values, it shouldn't go beyond 100%)
                                                                                                 

I think there might be problem with nested aggregation, I don't know how to fix it though.

Thank you in advance!

Best regards,

Mats

[Anonymous]

Hi suni,

thank you for your suggestions.

Unfortunately, none of these work.

Seems like there is a problem with the first one.

For the second one, QlikView just adds up all values, so it doesn't recognize the set expression either.

Really weird.

[Sergey_Shuklin]

Hello, Mats!

For cumulated values you can try to use a RangeSum() function. You can look here for clues:

Running count in percentage of‌