Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
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
Highlighted
Specialist III
Specialist III

Hi,

can you attach a sample file.

Highlighted
Specialist III
Specialist III

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.

Highlighted
Specialist
Specialist

Please check the data for my issue

Thanks

Neville

Highlighted
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

Highlighted
Specialist
Specialist

Thanks Vishwarath, It does work as I expect

Neville