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

Announcements
Join us in Bucharest on Sept 18th 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