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

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
Partner - Champion
Partner - Champion

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

Anonymous
Not applicable
Author

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

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 )