Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
warfollowmy_ver
Creator III
Creator III

how to create a trigger field updates after updating the field with a trigger

Hi all!


How to create a trigger field updates after updating the field with a trigger?

Examle in attachment. * moderator blocked, it does not say what you need to make corrections, so I do not know how to explain ... more


In the document properties to set a trigger to change the field or variable is useless!

That is again - choose the date, automatically change the 'date' field, and must then change week_trg. I don understand how!


7 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

HI!

I'd be happy to help, but I don't quite understand what are you trying to do... Can you explain your needs in Russian, and I'll try to offer a solution?

cheers,

Oleg Troyansky

Check out my new book QlikView Your Business - The Expert Guide for QlikView and Qlik Sense

sunny_talwar

May be like attached

warfollowmy_ver
Creator III
Creator III
Author

No thanks. I need to automatically load the trigger in the field week_trig.

In document contains the bottom steps

warfollowmy_ver
Creator III
Creator III
Author

Good afternoon.
It is necessary to make the auto-update field week trig, it is right.
The meaning of what I choose in the input field datu1, analysis days, then considered Date2, changing daty2 as a variable, the trigger is activated and changes the selection in the "choice" between Date1 and Date2.
If you change the date in the "date", it is probably possible values ​​vary weeks. It is necessary that the maximum week in the master data was week_trig weeks in the field in the data island. So far only managed to make a button through - the choice in the field.
In the properties of the document triggers on the variables and the field could not be used. I do not know why, the choice of n field is changed after a trigger and a new trigger is not activated.

warfollowmy_ver
Creator III
Creator III
Author

Anybody know? I don't know, but it's important

warfollowmy_ver
Creator III
Creator III
Author

Decision through macro. Macro bind to trigger of change variable Date2. P.S. I can not believe that this software can not make it easier.


Sub Decision

Date1 = ActiveDocument.Variables("Date1").GetContent.String

Date2 = ActiveDocument.Variables("Date2").GetContent.String

SelectDate = "<=" & Date1 & ">=" & Date2

ActiveDocument.Fields("Date").Select SelectDate

End sub

qliksus
Specialist II
Specialist II

Hi

Add one more trigger on Change of the variable Date2 like

Field :  Week_trig

Search String ='('&Concat(Week,'|')&')'

So when ever you change the dates it will automatically select the values in the Week_trig