Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
try ?* as search string. That should select all values with more than 0 characters, i.e. exclude the blank values.
Hi Steen
Try ISNULL function
Lukasz
Can you post an example document that shows this behavior?
Peter
Hi,
Try <> without any blank space like
<>''"
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..:-).
I don't think this will make any difference, because the field doesn't contain any NULL values.
/Steen
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
Hi,
Steen, this is the text box by default.
When you write = , QlikView can see exspresion.
You need write:
='<> '
Regards,
Yevgeniy
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