topic Re: Simple Button action does not work in QlikView

Simple Button action does not work

sspe — Wed, 18 Sep 2013 11:42:17 GMT

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

Re: Simple Button action does not work

Gysbert_Wassenaar — Wed, 18 Sep 2013 11:47:27 GMT

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

Re: Simple Button action does not work

Wed, 18 Sep 2013 11:47:50 GMT

Hi Steen

Try ISNULL function

Lukasz

Re: Simple Button action does not work

Peter_Cammaert — Wed, 18 Sep 2013 11:48:17 GMT

Can you post an example document that shows this behavior?

Peter

Re: Simple Button action does not work

Wed, 18 Sep 2013 11:52:01 GMT

Hi,

Try <> without any blank space like

<>''"

Re: Simple Button action does not work

sspe — Wed, 18 Sep 2013 11:57:23 GMT

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..:-).

Re: Simple Button action does not work

sspe — Wed, 18 Sep 2013 11:57:57 GMT

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

/Steen

Re: Simple Button action does not work

sspe — Wed, 18 Sep 2013 11:59:28 GMT

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

Re: Simple Button action does not work

yevgeniy — Wed, 18 Sep 2013 12:28:01 GMT

Hi,

Steen, this is the text box by default.

When you write = , QlikView can see exspresion.

You need write:

='<> '

Regards,

Yevgeniy

Re: Simple Button action does not work

ngulliver — Wed, 18 Sep 2013 12:30:21 GMT

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

Re: Simple Button action does not work

Wed, 18 Sep 2013 13:34:08 GMT

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"

Re: Simple Button action does not work

Wed, 18 Sep 2013 15:31:42 GMT

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.