Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Help with an expression

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.

14 Replies
sunny_talwar

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

Anonymous
Not applicable
Author

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
Not applicable
Author

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
Not applicable
Author

It must me nulls.

nicu1996
Contributor III
Contributor III

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