topic Re: Select in field trigger should choose only one value, right? in QlikView

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

dapostolopoylos — Mon, 26 Feb 2018 12:08:10 GMT

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

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

sunny_talwar — Mon, 26 Feb 2018 12:13:02 GMT

May be try with this

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

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

dapostolopoylos — Mon, 26 Feb 2018 12:19:21 GMT

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

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

sunny_talwar — Mon, 26 Feb 2018 12:21:18 GMT

How about this

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

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

dapostolopoylos — Mon, 26 Feb 2018 12:25:34 GMT

Neither...

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

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

sunny_talwar — Mon, 26 Feb 2018 12:34:56 GMT

Seems to be working for me in the attached file

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

dapostolopoylos — Mon, 26 Feb 2018 12:52:51 GMT

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

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

sunny_talwar — Mon, 26 Feb 2018 12:55:15 GMT

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

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

dapostolopoylos — Mon, 26 Feb 2018 13:30:49 GMT

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

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

pablolabbe — Wed, 28 Feb 2018 09:08:22 GMT

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

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

dapostolopoylos — Wed, 28 Feb 2018 12:14:03 GMT

I have already marked Sunny's last post as helpful, two days ago...

The problem was that another trigger (Replace bookmark) was messing up the selections....

Nevertheless i will mark Sunny's anwser as the Correct if you think it' more helpful for the communtity...

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

sunny_talwar — Wed, 28 Feb 2018 12:19:29 GMT

You don't have to mark my response as correct as long as your close the thread. The problem is that when a thread is not closed, people who are trying to help might come in to see that the issue has already been resolved. There are other ways to close the thread, in case you don't want to mark any response as correct. One of which is to mark the thread as Assumed Answer.

Look here

Qlik Community Tip: Marking Replies as Correct or Helpful