Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

How to set trigger on select in field?

Hi!

Could you help me with a little problem?)


I have two calendars organized through a listbox. One calendar for one sheet, the second for another. When moving from one project sheet to another, I need to select the maximum month in calendars.


How to set trigger or smthng else?



1 Solution

Accepted Solutions
Highlighted

Re: How to set trigger on select in field?

In the 'Sheet Properties' -> Trigger -> On Activate Sheet ->

Select In Field      -> Field (Month field)

    Search String -> =Date(Max({1}Date),'MMM')

View solution in original post

5 Replies
Highlighted

Re: How to set trigger on select in field?

In the 'Sheet Properties' -> Trigger -> On Activate Sheet ->

Select In Field      -> Field (Month field)

    Search String -> =Date(Max({1}Date),'MMM')

View solution in original post

Highlighted
Valued Contributor

Re: How to set trigger on select in field?

Go to 'Sheet Properties' -> Trigger -> On Activate Sheet ->

Select In Field      -> Field (Monthname)

Search string- =maxstring(Monthname)

Highlighted
New Contributor

Re: How to set trigger on select in field?

Thanks a lot!

Highlighted
New Contributor

Re: How to set trigger on select in field?

Thank you!)

Highlighted
Honored Contributor III

Re: How to set trigger on select in field?

If your question is now answered, please flag the Correct Answer (via the big "Correct Answer" button near every post; not visible in preview) and Helpful Answers (found under the Actions menu under every post).

If not, please make clear what part of this topic you still need help with .

May you live in interesting times!