Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
sspe
Creator II
Creator II

Simple Button action does not work


Hi,

I'm trying to make a simple button, that can leave out all contacts that hasn't got an email address.

I have created the Button, and added a "Select inf Field" action. First I'd just like to leave out all the contacts where the email adress is '' (just an empty string).

I have chosen the email field and then the search string I have entered is "<>'' ", but this doesn't work - it simply doesn't do anything. If I then instead change it to "=''" I get a list of customers where the email address is blank.

I can't figure out why the = works but the <> doesn't since there is definately contacts with a blank email.

I'm new to Qlickview, so maybe there are other ways to do this, but I think this should be fairly simple and straightforward.

Regards

Steen

11 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

try ?* as search string. That should select all values with more than 0 characters, i.e. exclude the blank values.


talk is cheap, supply exceeds demand
Not applicable

Hi Steen

Try ISNULL function

Lukasz

Peter_Cammaert
Partner - Champion III
Partner - Champion III

Can you post an example document that shows this behavior?

Peter

Not applicable

Hi,

Try <> without any blank space like

<>''"

sspe
Creator II
Creator II
Author

Hi,

It seems like this leave out the ones with a blank email address, so it could be a solution. It doesn't seems to be described in the Help though, so do you have any reference to this syntax?

I'd still like to be able to get it working with the <>'' syntax, so if any one have any tips I'd be happy..:-).

sspe
Creator II
Creator II
Author

I don't think this will make any difference, because the field doesn't contain any NULL values.

/Steen

sspe
Creator II
Creator II
Author

I have already tried it without spaces and that doens't make any difference. I have also tried with "" and () and {} and various other ways I have been able to find by googling the issue, but to no avail.

/Steen

yevgeniy
Creator
Creator

Hi,

Steen, this is the text box by default.

When you write = ,  QlikView can see exspresion.

You need write:

='<> '

Regards,

Yevgeniy

ngulliver
Partner - Specialist III
Partner - Specialist III

Hi, Steen

Have a look at Steve's blog.

It has best practices and examples to copy.

http://www.quickintelligence.co.uk/qlikview-buttons/

Regards,

Neil