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.

[Anonymous]

Ok, what I'm looing for the expression to include are lines that have no value in either of the accounts specified in the expression.

The no value is missing data I assume.

How can I change my expression to include those lines?

[sunny_talwar]

You will have to change your data model to generate missing data. Can't think of another way

Generating Missing Data In QlikView

[agigliotti]

could you provide a sample app with mock data to look into ?

[Anonymous]

This has always worked for me:

if(isnull (YOURFIELD )or Len(Trim (YOURFIELD ))=0,'Missing',YOURFIELD ) as YOURFIELD ,

If YOURFIELD contains no data, this will fill the field with 'Missing' and leave the values that exist alone.

[Anonymous]

Thanks, this worked.

I used the following expression:

if(isnull (sum({$<Account={4645,4643,4644,4646,4648,4649}>}ClaimCost) )or Len(Trim (sum({$<Account={4645,4643,4644,4646,4648,4649}>}ClaimCost) ))=0,'Missing',ReceiptValueGroupCurrency )