Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

madeleine_josef
Contributor

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

Re: Help with an expression

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

madeleine_josef
Contributor

Re: Help with an expression

This is what my table looks like:

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

Re: Help with an expression

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

madeleine_josef
Contributor

Re: Help with an expression

Yes, that box is checked.

Re: Help with an expression

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

Re: Help with an expression

Look here to see difference between missing and null

NULL handling in QlikView

madeleine_josef
Contributor

Re: Help with an expression

It must me nulls.

Highlighted
nicu1996
New Contributor III

Re: Help with an expression

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.

Re: Help with an expression

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