topic Re: how to active sheet using trigger on a field based on another corresponding field? in QlikView https://community.qlik.com/t5/QlikView/how-to-active-sheet-using-trigger-on-a-field-based-on-another/m-p/1119760#M369211 <HTML><HEAD></HEAD><BODY><P>can you provide the sample?</P></BODY></HTML> Thu, 21 Jul 2016 18:52:12 GMT settu_periasamy 2016-07-21T18:52:12Z how to active sheet using trigger on a field based on another corresponding field? https://community.qlik.com/t5/QlikView/how-to-active-sheet-using-trigger-on-a-field-based-on-another/m-p/1119759#M369210 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have two dimensions business unit&nbsp; and branch code along with facts in the first level report and&nbsp; I created field event trigger on branch code to navigate second level report.in the second level report also same two dimensions are available along with different dimensions and facts.<BR />Here business unit have vaues like 1,2,3&nbsp; and the corresponding branch code values in the report like a,a,b.when I click on first value 'a' of branch code then it is navigates second level report but in the second level report the values displayed like 1-a,2-a.but I want to seeselected branch code and business unit(1-a) value only I don't want to display other business unit and it's branch code values in the second level report.<BR />Is it possible in the Qlikview? Please suggest and provide me solution on this.<BR />I fetching data from excel only now.<BR />Many thanks in advance......</P></BODY></HTML> Thu, 21 Jul 2016 17:43:09 GMT https://community.qlik.com/t5/QlikView/how-to-active-sheet-using-trigger-on-a-field-based-on-another/m-p/1119759#M369210 srinivas1921 2016-07-21T17:43:09Z Re: how to active sheet using trigger on a field based on another corresponding field? https://community.qlik.com/t5/QlikView/how-to-active-sheet-using-trigger-on-a-field-based-on-another/m-p/1119760#M369211 <HTML><HEAD></HEAD><BODY><P>can you provide the sample?</P></BODY></HTML> Thu, 21 Jul 2016 18:52:12 GMT https://community.qlik.com/t5/QlikView/how-to-active-sheet-using-trigger-on-a-field-based-on-another/m-p/1119760#M369211 settu_periasamy 2016-07-21T18:52:12Z