topic Re: Action Trigger: Not Equal to NULL/BLANKS in QlikView

Action Trigger: Not Equal to NULL/BLANKS

kfahri342 — Wed, 09 Aug 2017 22:07:18 GMT

Hi All

I have the following column:

Type A
Dec-17
Jan-18
TBC

Aug-17

As you can see there is a mixture of dates, text and NULL values in this column. I have created a button where I want to TOGGLE SELECT "Type A" to only select Non-Null values.

I have tried the follow: <>"". But this only seems to show me the dates, and does not include the TBC. Is there a formula where I can select any that isn't NULL?

Many Thanks

Kozan

Re: Action Trigger: Not Equal to NULL/BLANKS

Anonymous — Wed, 09 Aug 2017 22:12:08 GMT

How about

=len([Type A])<>0

Re: Action Trigger: Not Equal to NULL/BLANKS

kfahri342 — Wed, 09 Aug 2017 22:22:46 GMT

Thanks for the suggestion. But that has no affect

Re: Action Trigger: Not Equal to NULL/BLANKS

Anonymous — Wed, 09 Aug 2017 22:33:49 GMT

Try attached

Re: Action Trigger: Not Equal to NULL/BLANKS

kfahri342 — Wed, 09 Aug 2017 22:39:42 GMT

This works perfectly. Cheers Wallo.

For one of my columns I would need it to include all NON-BLANKS except for those marked N/A? Is this do-able? I tried using an AND function but either I am not typing it right or it doesn't work.