Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
kfahri342
Contributor III
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
Specialist II
Specialist II

How about

=len([Type A])<>0

kfahri342
Contributor III
Contributor III
Author

Thanks for the suggestion. But that has no affect

atkinsow
Specialist II
Specialist II

Try attached

kfahri342
Contributor III
Contributor III
Author

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.