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
Not applicable

Hi Steen,

Have you tried allowing for this in the scripting ?

eg :

if(isnull(emailaddress),'None',emaileaddress) as emailaddress,

You could then make the button select "None"

Not applicable

Hi,

In Button actions, Add action as select in field and search string is "". (empty).

Then add Select exclude action and use that same field.

Hope it helps.