topic Re: Field Tiggers in QlikView

Field Tiggers

mparker123 — Wed, 25 Nov 2020 16:16:04 GMT

Hello All,

I am having trouble with the field triggers. I have a straight table on one tab, within this straight table I have a field called epic_summary. I am setting a field trigger on this field so when I click on it, it will take me to the the next tab and show me the filtered items. (I have tried Activate sheet, Activate Next Sheet, and Set Variable) These work but it also mess my document.

For instance I have 5 tabs and the field appears on each tab, when I am on the 1st tab and click on the field it takes me to the 2nd tab which is want i want it to do. However, when I click on the same field on the 3rd and 4th tab it will do the same things. I want it so that the first tab and second table filter together and the rest do not.

Is this at all possible and if it is how is this done?

Re: Field Tiggers

krishnacbe — Mon, 25 Sep 2017 13:10:25 GMT

Hi,

You can add another condition with GetActiveSheetId() along with Field Trigger and create a Variable value with AND Condition.

Re: Field Tiggers

prieper — Mon, 25 Sep 2017 13:13:33 GMT

Think that you will have to create another field, without the above trigger.

edit:

Krishnapriya's solution looks better

Re: Field Tiggers

mparker123 — Mon, 25 Sep 2017 14:12:28 GMT

Can you please elaborate.

I go into document properties and I select the field in the Field Event Triggers box. I am presented with 4 options (OnSelect, OnChange, OnLock, OnUnlock). I click on the add action on the OnSelect option. I click add and go to the action type LAYOUT and select the action ACTIVATE SHEET. Here it just ask for a Sheet ID so I assume this is not what you mean.

I go into document properties and I select the field in the Field Event Triggers box. I click on the add action on the OnSelect option. I click add and go to the action type EXTERNAL and select the action SET VARIABLE. In this expression i write a condition with GetActiveSheetId() but use an and statement to control what sheet and when do i want it activated.

Re: Field Tiggers

krishnacbe — Mon, 25 Sep 2017 14:16:20 GMT

I meant the second option you explained

Re: Field Tiggers

krishnacbe — Mon, 25 Sep 2017 14:32:28 GMT

I tried below expression OnSelect() event of the Field Event Trigger. It worked.

=if(GetActiveSheetId()='Document\SH11','SH09','SH08')

Re: Field Tiggers

vvira1316 — Mon, 25 Sep 2017 14:57:33 GMT

Have you explored alternative state for sheet 3 and 4 (may be other sheets and fields all will have to be in the same state so will have different interaction). so filter field will have a one state for sheet 1 and 2. They will behave in sync and due to alternative state on 3 and 4 it will not impact them and vice versa.

Re: Field Tiggers

mparker123 — Mon, 25 Sep 2017 20:30:52 GMT

That works, however if I Move to a tab not included in the expression above, when I go to filter a straight table on this new tab with the epic_summary field the straight table disappears and I have to click out of the tab and go back into the tab to see the filtered table. Is there a way to fix this?

Re: Field Tiggers

mparker123 — Mon, 25 Sep 2017 20:41:01 GMT

I have set alternate states as well, this does not seem to solve the issue of the straight table disappearing.

Re: Field Tiggers

krishnacbe — Mon, 25 Sep 2017 20:42:01 GMT

For testing I Tried navigating to other tab in the expression. Hope in your expression the else will be blank.. Am I right?

Re: Field Tiggers

krishnacbe — Mon, 25 Sep 2017 20:44:32 GMT

If possible share the qvw with limited data

Re: Field Tiggers

vvira1316 — Tue, 26 Sep 2017 15:22:26 GMT

Hi Matt,

Will you be able to share the app? That will help to help you. You can reduce and mask data for confidentiality.

I may try with a straight data table I may have but would help with your data and app hence the request.

BR,

Vijay

Re: Field Tiggers

vvira1316 — Tue, 26 Sep 2017 16:04:15 GMT

Hi Matt,

Please see attached sample.

Re: Field Tiggers

mparker123 — Tue, 26 Sep 2017 19:23:29 GMT

Hey ViJay,

I looked at your qlikview and it is essentially what I am trying to do. However, in your sample it seems that when you go to clear the document it brings you to Sheet2 and when you select a filter on Sheet 3 it brings you back to Sheet 2. When I select clear I would like to clear and stay on the tab I am on and also when i select a filter on sheet 3 I would like it to stay on sheet 3. Is this at all possible?

Re: Field Tiggers

vvira1316 — Tue, 26 Sep 2017 19:58:55 GMT

Hi Matt,

Yes, I did notice that behavior and I thought you are looking for functionality you have described in response to sample I had provided. Yes I think it is possible, it will have to controlled using some variables. I'll try to do it.

BR,

Vijay

Re: Field Tiggers

mparker123 — Tue, 26 Sep 2017 20:36:54 GMT

Ok thank you

Re: Field Tiggers

krishnacbe — Tue, 26 Sep 2017 20:46:29 GMT

Hi, Please find the attached Solution to ignore the Clear Issue. Hope it helps.

Below is the Expression used to Activate the Sheet.

=if(GetActiveSheetId()='Document\SH01' and GetSelectedCount(Mob)>=1,'SH02')

Re: Field Tiggers

vvira1316 — Wed, 27 Sep 2017 21:46:22 GMT

Hi Matt,

Here it is. Sorry for the delay.

Re: Field Tiggers

vvira1316 — Thu, 28 Sep 2017 16:57:38 GMT

Hi Matt,

If you have the solution then can you please close the thread.

BR,

Vijay

Re: Field Tiggers

vvira1316 — Tue, 10 Oct 2017 18:35:43 GMT

Hi Matt,

I hope you have found answer to your question.

Qlik Community Tip: Marking Replies as Correct or Helpful

If so, please close the thread.

BR,

Vijay