topic Re: Why symbol - is not picked up by Set Expression in QlikView

Why symbol - is not picked up by Set Expression

nevilledhamsiri — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Why symbol - is not picked up by Set Expression

mdmukramali — Sun, 02 Sep 2018 04:32:34 GMT

Hi,

can you attach a sample file.

Re: Why symbol - is not picked up by Set Expression

Or — Sun, 02 Sep 2018 07:18:51 GMT

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.

Re: Why symbol - is not picked up by Set Expression

nevilledhamsiri — Mon, 03 Sep 2018 17:21:06 GMT

Please check the data for my issue

Thanks

Neville

Re: Why symbol - is not picked up by Set Expression

vishsaggi — Mon, 03 Sep 2018 21:47:37 GMT

May be try this?

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

Re: Why symbol - is not picked up by Set Expression

nevilledhamsiri — Tue, 04 Sep 2018 17:21:39 GMT

Thanks Vishwarath, It does work as I expect

Neville