Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
dapostolopoylos
Contributor III

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

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

Father/Husband/BI Developer
1 Solution

Accepted Solutions

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

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

View solution in original post

11 Replies

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

May be try with this

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

dapostolopoylos
Contributor III

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

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

Capture.JPG

Father/Husband/BI Developer

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

How about this

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

dapostolopoylos
Contributor III

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

Neither...

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

Father/Husband/BI Developer

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

Seems to be working for me in the attached file

dapostolopoylos
Contributor III

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

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

Father/Husband/BI Developer

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

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

View solution in original post

dapostolopoylos
Contributor III

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

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

Father/Husband/BI Developer
Luminary
Luminary

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

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