Null Values in Above() function produce wrong results

[MuraliPrasath]

Hi,

I'm using following expression to get my accumulation values. but if I get any null values in the dimension then my accumulation sum is giving wrong result. Can some one help me on this?

=Range Sum(Above(TOTAL sum(SYSTEMS),0, Row No(TOTAL)))

[lorenzoconforti]

Works fine for me. Can you share your dashboard? 

[sunny_talwar]

Would you be able to share a sample where we can see the issue?

[MuraliPrasath]

I'm using Qlik Sense Cloud. How can I share my app? 

[marcus_sommer · Accepted solution]

It's not an error within the above-function else within your table-design - in which for any reasons some countries are listed twice. If you remove the cause of it the above() will work again like expected.

Alternatively you may try to identify the NULL or maybe counting the number of countries within your table to adjust your expression but it could become difficult - nevertheless you may try something like this:

Range Sum(Above(TOTAL if(len(ExpressionForMaxSystems), sum(SYSTEMS), 0),0, Row No(TOTAL)))

- Marcus

[lorenzoconforti]

How to export the app:

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Apps/export-apps-cloud-h...

[MuraliPrasath]

Thanks you! I had data model issues with the key field that causes duplicates and fixed it now and it works fine. 

Have a great day. Stay safe at home. Thanks😊