topic Action on Text Boxes Issue in QlikView

Action on Text Boxes Issue

alec1982 — Tue, 09 Sep 2014 20:14:34 GMT

Hi guys,

I have two text boxes with action on each of them to assign a value in a list box.

When I click on the first text box I get the right value .. When I click on the second box It clears all the data and then if I click on it again It select the right value within the list box.

On the actions i have set analysis as show below:

=max({$<[Fiscal Week Review - FYFlag]={'+1'}>}[Fiscal Week Review - FY NumFlag])

Any idea?

Best,

Alec

Re: Action on Text Boxes Issue

Tue, 09 Sep 2014 20:23:05 GMT

Would it be possible to share a sample qvw?

Re: Action on Text Boxes Issue

Tue, 09 Sep 2014 22:39:30 GMT

Hi,

Add an other action in the first text box (Lock all) and thats all.

Tell if it works.

Regards.

Re: Action on Text Boxes Issue

danieloberbilli — Tue, 09 Sep 2014 23:44:46 GMT

I agree with Oswaldo. Or additional set a certain variable =1 if the first textbox is already clicked to indicate that the desired effect is already there and use this condition in other action-textboxes to avoid further actions

Re: Action on Text Boxes Issue

alec1982 — Wed, 10 Sep 2014 04:37:25 GMT

Hi guys,

Thank you for the help..

The second text box has slightly different expression to select different value in the same list box

=max({$<[Fiscal Week Review - FYFlag]={'-1'}>}[Fiscal Week Review - FY NumFlag])

When I click on the first text box.. the action work correctly. then I go to the second text box and click.. it clears the selection and doesn't make the required selection.. when I click on it again it select the right value..

Not there is no additional actions on any of the boxes not even Clear All.

Hope that explain the situation and get some help.

Best,

Alec

Re: Action on Text Boxes Issue

PrashantSangle — Wed, 10 Sep 2014 04:44:34 GMT

Hi,

Then add one additional action on both text object

Add Clear Field action on both text object, pramote them to top then write your second action.

Hope this will help you.

Regards,

Re: Action on Text Boxes Issue

rwunderlich — Wed, 10 Sep 2014 04:45:12 GMT

I'm guessing your problem is in the use of "$" as your set identifier.

=max({$<[Fiscal Week Review - FYFlag]={'-1'}>}[Fiscal Week Review - FY NumFlag])

The value you are trying to compute is not available in the current selections. Try changing the "$" to "1" to see if it works. it may be that you want to honor some of the selections. but try the "1" as a test and then follow up.

-Rob

Re: Action on Text Boxes Issue

alec1982 — Wed, 10 Sep 2014 04:46:53 GMT

Rob,

Thank you.. I was typing the solution I figured which is exactly what you have provided.

Best,

Alec