Select in field trigger should choose only one value, right?

[dapostolopoylos]

I'm facing this weird situation and i would like some help...

In my Qlikview app i have created a Month dimension with values 1 to 12 (obviously)...

I added a "OnOpen" trigger where i created a "Select In Field" action on the Month field where the Search String equals

=If(Num(Month(Today()))=1, 12, Month(Today())-1)

When my app opens the values 1,10,11,12 are selected...

When i run the same trigger with a button to test the code only value 1 is selected...

The Default Search Mode of the document is Normal...

What am i missing here???

P.S. I have created the same trigger in another Qlikview document and it works fine....

[sunny_talwar]

May be try with this

='("' & If(Num(Month(Today()))=1, 12, Month(Today())-1) & '")'

[dapostolopoylos]

No, unfortunately it doesn't work, it does exactly the same thing...

[sunny_talwar]

How about this

='=Month = Num(Month(AddMonths(Today(), -1)))'

[dapostolopoylos]

Neither...

The thing is that it works like a wildcard search and i cannot understand why...

[sunny_talwar]

Seems to be working for me in the attached file

[dapostolopoylos]

Something is wrong with the document...

I have tried the code from my original post in a new document and it works fine...

The problem is that the document that the problem appeared is a production document...

[sunny_talwar · Accepted solution]

May be you have other triggers? Difficult to know without playing with it

[dapostolopoylos]

You sure have a point my friend!

It seems that the problem is created by another trigger where i stored in a bookmark the initial filter selection of the document in order to give the end user the option to reset filters...

Something is not working as it should with the Replace Bookmark action, i wll work on that to see what's going on...

[pablolabbe]

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others