Action on Text Boxes Issue

[alec1982]

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

[#2]

Would it be possible to share a sample qvw?

[#3]

Hi,

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

Tell if it works.

Regards.

[danieloberbilli]

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

[alec1982]

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

[PrashantSangle]

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,

[rwunderlich · Accepted solution]

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

[alec1982]

Rob,

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

Best,

Alec