Help with an expression

[Anonymous]

Hi,

I have an expression that I would like help with.

sum({$<Account={4645,4643,4644,4646,4648,4649}>}ClaimCost)

How can I write my expression so that lines with no value in this expression shows up in the table?

Thanks.

[sunny_talwar]

no value? can you elaborate and may be share an image?

[Anonymous]

This is what my table looks like:

I would like assignments to show up in the table eventhough they have no claimcost.

[sunny_talwar]

Can you check if you have checked 'Include Zero Values' under Add-Ons -> Data handling?

[Anonymous]

Yes, that box is checked.

[sunny_talwar]

Are you dealing with 0's or nulls or are you dealing with missing data?

[sunny_talwar]

Look here to see difference between missing and null

NULL handling in QlikView

[Anonymous]

It must me nulls.

[nicu1996]

You can use the Alt() function: alt  - script and chart function ‒ Qlik Sense

Something like this:
Alt(Sum({$<Account={4645,4643,4644,4646,4648,4649}>}ClaimCost), 'No value').

If there is a Sum of ClaimCost, it will be displayed, otherwise 'No value' will be displayed. Also, you can change the 'No value' text. You can put '-', but not null.

[sunny_talwar]

Nulls are not a problem, but missing data is... read through the document to understand the difference between the two