topic Re: Trigger for Different Selection of fields for different Objects on activate sheet Action in QlikView

Trigger for Different Selection of fields for different Objects on activate sheet Action

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

Please find the below example of my requirement .

I have two objects CH01and CH02 (which are linked objects fromSheet1)

and two fields system and subsystem in Sheet2.(System is again classified into subsystems)

Now I want to apply a triggers

1) which can select field system='Fruit' for object CH01

2)select field system='Fruit' and subsystem='Orange' for CH02.

either 1) or 2) I can achieve by using OnActivateSheet-> SelectinField

And OnLeaveSheet->ClearAll.

How to merge both the conditions for making the two objects works as required on activate sheet.

Re: Trigger for Different Selection of fields for different Objects on activate sheet Action

Gysbert_Wassenaar — Fri, 04 Aug 2017 11:04:36 GMT

Change the expressions in object CH01 so they ignore selections in the field subsystem. For example an expression sum(Amount) would be changed in sum({<subsystem=>}Amount).

Re: Trigger for Different Selection of fields for different Objects on activate sheet Action

Fri, 04 Aug 2017 11:19:48 GMT

Hi Gysbert,

The objects CH01 and CH02 are linked objects from sheet2.

So I cannot change the expression in the objections.

Please let me know if there is any other way.

Re: Trigger for Different Selection of fields for different Objects on activate sheet Action

Gysbert_Wassenaar — Fri, 04 Aug 2017 11:39:32 GMT

If they are linked objects then they are the same object in two different places. You will never get one object to be in two states at once. That cat is either dead or alive, but never both. Solution: use two charts.