topic Re: Null Values in Above() function produce wrong results in App Development

Null Values in Above() function produce wrong results

MuraliPrasath — Sat, 16 Nov 2024 02:48:49 GMT

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)))

Re: Null Values in Above() function produce wrong results

lorenzoconforti — Thu, 02 Apr 2020 15:18:56 GMT

Works fine for me. Can you share your dashboard?

Re: Null Values in Above() function produce wrong results

sunny_talwar — Thu, 02 Apr 2020 15:35:33 GMT

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

Re: Null Values in Above() function produce wrong results

MuraliPrasath — Fri, 03 Apr 2020 01:51:38 GMT

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

Re: Null Values in Above() function produce wrong results

marcus_sommer — Fri, 03 Apr 2020 09:06:51 GMT

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

Re: Null Values in Above() function produce wrong results

lorenzoconforti — Fri, 03 Apr 2020 09:10:59 GMT

How to export the app:

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

Re: Null Values in Above() function produce wrong results

MuraliPrasath — Sat, 04 Apr 2020 12:22:38 GMT

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😊