Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
kfahri342
New Contributor III

Action Trigger: Not Equal to NULL/BLANKS

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

4 Replies
atkinsow
Valued Contributor II

Re: Action Trigger: Not Equal to NULL/BLANKS

How about

=len([Type A])<>0

kfahri342
New Contributor III

Re: Action Trigger: Not Equal to NULL/BLANKS

Thanks for the suggestion. But that has no affect

atkinsow
Valued Contributor II

Re: Action Trigger: Not Equal to NULL/BLANKS

Try attached

kfahri342
New Contributor III

Re: Action Trigger: Not Equal to NULL/BLANKS

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.