Skip to main content
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