Field Tiggers

[mparker123]

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?

[krishnacbe]

If possible share the qvw with limited data

[vvira1316]

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

[vvira1316]

Hi Matt,

Please see attached sample.

[mparker123]

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?

[vvira1316]

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

[mparker123]

Ok thank you

[krishnacbe]

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')

[vvira1316]

Hi Matt,

Here it is. Sorry for the delay.

[vvira1316]

Hi Matt,

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

BR,

Vijay

[vvira1316]

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