topic AW:Re: AW:Fire a Trigger When User Changes an Variable (formularesult) in QlikView

Fire a Trigger When User Changes an Variable (formularesult)

Fri, 20 Aug 2010 09:01:21 GMT

I have big problem on something like thisone:

http://qlikviewmaven.blogspot.com/2010/07/fire-trigger-when-user-changes-input.html

My variable: $(FirmaAnzahl) = getselectedcount(Firma_FIBU_NrBez)+1

If user changes his selection on Firma_FIBU_NrBez from lets say 3 to 4 it should fire based on "trigger on variable". From 4 to 0, from 0 to2 it always should fire. BUT it don't. I knew somewhere in past it did fire.For now the trigger on variable thing only works, if user is realy changeing something on that variable manualy (e.g. Inputbox). Changes on variable made through a formula - like mine - do not trigger anything. [:S]

To workaround I set trigger on select my field "Firma_FIBU_NrBez". But problem is, that this do not work all the time. If user selects something in other field which deselects "Firma_FIBU_NrBez" trigger wont fire. If the user uses a bookmark, trigger wont fire. It just fires on really selecting the triggered field.

The solution on variable-change always fired - the time it worked 😞 ! Now it do not work any longer. I think the manual and the help give examples on that this a formula for variable. So I think, that this is a bug for sure.

Anyone have a similar Problem and another solution?

Greets,
Jonas

AW:Fire a Trigger When User Changes an Variable (formularesult)

Fri, 10 Sep 2010 08:23:05 GMT

Something new on this one? Perhaps someone tested on 10.0 RC 2?

AW:Fire a Trigger When User Changes an Variable (formularesult)

Fri, 10 Sep 2010 08:52:21 GMT

Hi Jonas,

The trigger what you are expecting never will be fired, if you see, the literal variable value never changes, I mean, always is gonna be =getselectedcount(F1), so, the change really doesn't happen.

What are you trying really? would always it depends of a selection?

Regards.

AW:Re: AW:Fire a Trigger When User Changes an Variable (formularesult)

Fri, 10 Sep 2010 09:04:32 GMT

Hi,

you are absolutly right in idea but I have to tell you, that thisone worked previous version 9.0 SR3. I used it some day before update. Trigger on Variable with formula (first literal = "=") should not fire on literal change but on formula result. It's how I said - this worked some day in past.

QV-Help also tells you it should work the way I want it workin. I'm just waiting for fix.

Regards

AW:Re: AW:Fire a Trigger When User Changes an Variable (formularesult)

Fri, 10 Sep 2010 09:10:13 GMT

Hi Jonas,

I have the 9.00.7469.8 SR4, and it doesn't work for me either. That is very strange.

Regards.

AW:Re: AW:Re: AW:Fire a Trigger When User Changes an Variable (formularesult)

Fri, 10 Sep 2010 10:08:29 GMT

Look at this one. Same problem. He sais SR2 should work. I am not able to test it. Perhaps someone has this older version running on server or lokaly.

http://community.qlik.com/blogs/qlikviewblogs/archive/2010/07/06/fire-a-trigger-when-user-changes-an-input-field.aspx

Fire a Trigger When User Changes an Variable (formularesult)

johnw — Fri, 10 Sep 2010 21:26:52 GMT


Jonas Gros wrote:To workaround I set trigger on select my field "Firma_FIBU_NrBez". But problem is, that this do not work all the time. If user selects something in other field which deselects "Firma_FIBU_NrBez" trigger wont fire. If the user uses a bookmark, trigger wont fire. It just fires on really selecting the triggered field.

You also need to trigger the macro OnChange. The OnSelect trigger only works for direct selections, as you've noticed. The OnChange trigger works for indirect selections like you are describing. See attached. F2 = F1. If you modify F1 directly, it triggers the macro with the OnSelect trigger. If you modify F1 indirectly by changing F2, it triggers the macro via the OnChange trigger. I have not verified that it works with bookmarks, but I would guess so.

Fire a Trigger When User Changes an Variable (formularesult)

Mon, 04 Oct 2010 15:00:54 GMT

The problem seems to be fixed with version 9.0 SR 6.