Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

madeleine_josef
Contributor

Re: Help with an expression

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?

Re: Help with an expression

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

Generating Missing Data In QlikView

Partner
Partner

Re: Help with an expression

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

jhlovenc
Contributor II

Re: Help with an expression

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.

Highlighted
madeleine_josef
Contributor

Re: Help with an expression

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 )