Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
rohanmayekar
Partner - Contributor III
Partner - Contributor III

Specific Trigger not working on QMC

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

qlikqn2.png

qlikqn3.png

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.

3 Replies
jerrysvensson
Partner - Specialist II
Partner - Specialist II

Hi

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.

rohanmayekar
Partner - Contributor III
Partner - Contributor III
Author

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?

jerrysvensson
Partner - Specialist II
Partner - Specialist II

You should use the supplied plugin version with QlikView server.

It will ONLY work with IE though.