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: 
nevilledhamsiri
Specialist
Specialist

Why symbol - is not picked up by Set Expression

As pr the set expression below, I need to pick records which has - mark .For that I have given this  '-'  but seems to be not working. Can you please see what the error is?

SUM({<CLRECTYP={'Foreign','Others','cyclone','-'},CLBAL={"=CLBAL=0"}>}RFCBAL)

Please refer straight table on the right hand side where  I tried to pick records of which CLRECTYP equal to null or - sign but it seems to be not working. Any help on this

Thanks in adavnce

Neville

1 Solution

Accepted Solutions
vishsaggi
Champion III
Champion III

May be try this?

= SUM({<CLBAL={"=CLBAL=0"},CLRECTYP={'Foreign','Others','cyclone'}>+<CLRECTYP ={"=len(trim(CLRECTYP))=0"}>}RFCBAL)

View solution in original post

5 Replies
mdmukramali
Specialist III
Specialist III

Hi,

can you attach a sample file.

Or
MVP
MVP

If you're trying to catch null values as '-', that's not how it works. '-' is strictly the display for nulls. The actual value remains null, which can't be directly selected in QliKView.

If you need to select your nulls, replace them with something else ('-' will work) at the script level.

nevilledhamsiri
Specialist
Specialist
Author

Please check the data for my issue

Thanks

Neville

vishsaggi
Champion III
Champion III

May be try this?

= SUM({<CLBAL={"=CLBAL=0"},CLRECTYP={'Foreign','Others','cyclone'}>+<CLRECTYP ={"=len(trim(CLRECTYP))=0"}>}RFCBAL)

nevilledhamsiri
Specialist
Specialist
Author

Thanks Vishwarath, It does work as I expect

Neville