Specific Trigger not working on QMC

rohanmayekar — Sun, 13 May 2018 21:03:58 GMT

Issue 1:

%JOIN_FactYeildPPVLabourDimDay = This is the field loaded from data model which stores day values [ eg. 20180509]

We have used above field in various expression on dashboard. This field is also used in set analysis of various expressions to display only day level data.

If this value is not set, then dashboard displays cumulative values which is incorrect.

Sample Expression :

=Num(sum({<WTDFlag={0},YTDFlag={0},MTDFlag={0}>}StdLabourCostGBP)-

sum({<WTDFlag={0},YTDFlag={0},MTDFlag={0}>}ActLabourCostGBP)

,'£#,##0;(£#,##0)')

To select the latest Date on dashboard, Triggers are used to set value of this field.

Triggers are used at various level,

Document level
Sheet level
Label – Action

Trigger expression:

%JOIN_FactYeildPPVLabourDimDay = Field=max({1<FlagFact={1},SourceDataFlag={'LC'}>}%JOIN_FactYeildPPVLabourDimDay)

This trigger is working fine on Qlikview Desktop version but when deployed on Access point triggers are not taking effect [ current selections on landing page does not show this field as selected]

Accesspoint url is accessed using both IE and Chrome. Still same issue.

Issue 2:

There are multiple tabs on App. We have used Text objects to switch between tabs.

When switched from one tab to other tab, Sheet level triggers [clear field] should take effect.

This is not happening on QV Access point , causing inappropriate data to be displayed on dashboard.

Re: Specific Trigger not working on QMC

jerrysvensson — Mon, 14 May 2018 08:26:22 GMT

OnOpen trigger doesn't work unless you use plugin.

In WebView it will not work, it could work once though if the session has timed out.

OnActivateSheet doesn't work in WebView either. Only plugin.

Re: Specific Trigger not working on QMC

rohanmayekar — Mon, 14 May 2018 08:32:12 GMT

Thanks Jerry for the reply.

We are currently using Qlikview 12.10.20600.0 SR8

IE 11

Google Chrome 65.0.3325.146

Could you please give me further details on which plugin i need to use?

Re: Specific Trigger not working on QMC

jerrysvensson — Mon, 14 May 2018 10:30:21 GMT

You should use the supplied plugin version with QlikView server.

It will ONLY work with IE though.

topic Re: Specific Trigger not working on QMC in QlikView

Specific Trigger not working on QMC

Re: Specific Trigger not working on QMC

Re: Specific Trigger not working on QMC

Re: Specific Trigger not working on QMC