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

Blank values with expression?

Hi,

I have straight table. I would need to show the values which have 'Instructions' with blanks

I used the below expression.

=If(Instruction='',Instruction)

will it gives the values only with blanks?

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

13 Replies
MK_QSL
MVP
MVP

May be

IF(ISNULL(Instruction), Instruction)

srchilukoori
Specialist
Specialist

a better way to identify the nulls and blanks is to use Len(Trim(<Field name>)) = 0

In your case:

=If(Len(Trim(Instruction)))=0', 'Instruction')

Not applicable
Author

Thanks. Just wrote it.

agilos_mla
Partner - Creator III
Partner - Creator III

if the ISNULL does not work, try this :

if(len(trim(Instruction))=0, Instruction)

srchilukoori
Specialist
Specialist

ISNULL() doesn't identify blank spaces.

Not applicable
Author

Thanks. it's not showing blanks . instead showing all. Any solution please.

Edit: will this works with table box?

Not applicable
Author

Thanks. This is not taking blank values. Any solution please

MK_QSL
MVP
MVP

As always, give us your sample data !

agilos_mla
Partner - Creator III
Partner - Creator III

Maybe it's a real white space: soft blanks (Chr(32)), hard blanks (Chr(160)), the tab character (Chr(09)) .

So try,  for soft blanks ,  if(len(trim(Instruction))=chr(32), Instruction)