topic Clear input box or use all possible value in QlikView

Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 15:59:34 GMT

Hi guys,

I have an input box. But when I move to another sheet, I'd like to clear my input box variable or set up - use all possible value.

How can I do it without using a macro?

Thanks,

Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 16:11:19 GMT

Use Triggers , on Activate Sheet---> add action ---External--set variable. Hope this helps

Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 16:13:12 GMT

I know it. But what should I set up in variable to clear or use all value?

Thanks,

Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 16:17:11 GMT

or how to set up show what I typed in Search box ?

Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 17:43:31 GMT

can you please let me know the definition of the variable or else sample application , i can be able to help you with that...

Re: Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 17:59:38 GMT

Please find the attached file.

I have a search box and input box. My chart is using Variable from Input box, but I can easy to redo to use Field from Search box.

The idea is by default chart shows all possible results. Using search box (or input box) hide unselected words. It works.

Problem with input box

--- But click by "Next" my variable from Input box should be cleared or used all possible value.

Problem with search box

--- Search field doesn't show what I typed

Thanks,

Re: Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 18:47:19 GMT

Why don't you use a list box and enable Hide Exclude option. So that Users will know what they have selected. And it will exclude what they haven't selected. And your expressions also work fine. Please correct me if i am missing anything

Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 18:48:14 GMT

For Input text

I can set up a trigger for variable

=concat(DISTINCT {<[Keyword]=P()>} Keyword, ', ')

in this case my input variable shows all possible value

Re: Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 18:55:33 GMT

I'm limited in a space.

Do you have an example, how to show my typed key word?

I'd like to have only *ja* or whatever I typed. I don't need to see all possible words, which have *ja*

Cheers,

Re: Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 19:02:56 GMT

Now i understood your problem is..so you want to see data for .. what you have typed... let me get back to you on that...

Re: Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 19:14:05 GMT

1. Show all value

2. show only Keyword, which has "all"

3. Clicking by Campaign or other tab my input box should be cleared or use all possible value.

I use a trigger

set variable=if(SubStringCount(concat(DISTINCT {<[Keyword]=P()>} Keyword, ', '), ', ' )>0, ExcludeKeyword)

In this case, when I move to another tab, my input box show all possible value

I try to find any solution how to show what I typed for search

Re: Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 19:34:50 GMT

not sure if there is a way to show what you have typed for search. But if you search something in search box and select it .. and if you want to show in a text box.. then use =GetFieldSelections(Keyword) in the text box...or use that in the variable .. that will be fix the issue...

Re: Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 20:11:35 GMT

Do you know how to get undefined condition for input box?

When I click "Delete" command and than "Enter", i got empty input box with undefined, and everything works

Re: Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 20:14:05 GMT

Not really i dont know.. may search in the support site. Is my solution helpful...

Re: Re: Clear input box or use all possible value

Anonymous — Wed, 28 May 2014 20:53:34 GMT

I probably find the issue

trigger for variable - chr(00)

Re: Re: Clear input box or use all possible value

Anonymous — Thu, 29 May 2014 12:31:51 GMT

Glad you found the solution Buddy

Re: Clear input box or use all possible value

Anonymous — Thu, 29 May 2014 13:43:42 GMT

Thank you for your help.

Re: Re: Clear input box or use all possible value

Fri, 03 Oct 2014 14:24:10 GMT

If you have no input constraints on your variable, this will happen.

Go to Settings > Document Settings > Variables > Input Constraints

You can also mange these constraints while you are configuring the input box.

Go to Input Box Properties > Constraints > Input Constraints