Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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....
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...
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