Why symbol - is not picked up by Set Expression

[nevilledhamsiri]

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

[mdmukramali]

Hi,

can you attach a sample file.

[Or]

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]

Please check the data for my issue

Thanks

Neville

[vishsaggi · Accepted solution]

May be try this?

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

[nevilledhamsiri]

Thanks Vishwarath, It does work as I expect

Neville