Qlik Sense Expression excluding nulls with condition.

[HH3571]

Hello, i have the following script in an KPI chart:

Sum({<ROW_ID = {$(=MAX(ROW_ID))}>} VOLUME).

= Find max row id and give the volume.

The problem is that, the Max ROW_ID can sometimes contain null values, which i'm not interested in.

Is there a way for the above  script to work, excluding null values for VOLUME ?

Best regards

H

[MayilVahanan · Accepted solution]

Hi

Try like below

Sum({<ROW_ID = {$(=MAX({<ROW_ID ={"=Sum(Volume)>0"}>}ROW_ID ))}>} VOLUME)

[HH3571]

Thank you it was correct answer.

Do you have any links/tips for learning material regarding set expressions, set analysis etc, like the above problem?

Do you think i should have done this in the Script editor instead of making an expression out of it, for convenience?

Best regards

H

[MayilVahanan]

Hi

For set analysis, you can learn lot of materials in Qlik community itself, for practice, you can watch videos in youtube. However, by practice, you can learn quicker 🙂

Its depends on the requirement / user agree to remove null values completely from the dashboard, you can remove those records in script itself.