topic Trigger to next sheet - Regarding in QlikView

Trigger to next sheet - Regarding

kkkumar82 — Thu, 07 Apr 2016 10:01:20 GMT

good afternoon,

I have a requirement like when I click SalesmanID in list box it should navigate me to the next sheet. I have achieved this by going to the field event triggers "on select" but I found some thing strange.

Lets assume in the attached file

Main sheet : SalesmanId

Sheet 1: some table

Sheet 2: another table

What I am getting is when I click in salesmanId in main sheet, it is navigating me to sheet1 and let us assume if I goto sheet2 and press "clear" it is again navigating to sheet1 which I don't want, in my original application also its happening if I am there in any sheet pressing clear, it is navigating to the sheet1 where I kept the original navigation.

Any suggestions here.

Kiran kumar

Re: Trigger to next sheet - Regarding

Chanty4u — Thu, 07 Apr 2016 10:07:03 GMT

chk sample same req i had previous.

Re: Trigger to next sheet - Regarding

Gysbert_Wassenaar — Thu, 07 Apr 2016 10:09:45 GMT

That's exactly the reason you should avoid using triggers to create this kind of magic behavior. In this case you could use a conditional expression that uses GetSelectedCount() to check if you have only one selected value in the field you're interested in. Something like =If(GetSelectedCount(SalesmanId)=1, 'SH02')

Re: Trigger to next sheet - Regarding

sunny_talwar — Thu, 07 Apr 2016 10:13:07 GMT

May be use this:

=If(SubField(GetActiveSheetId(), '\', 2) = 'SH01', 'SH02')

Re: Trigger to next sheet - Regarding

Chanty4u — Thu, 07 Apr 2016 10:13:14 GMT

u can create dummy dimension

in script lik

salesmanid as salesmanId1

and u can use this in document properties triggers lik below

Re: Trigger to next sheet - Regarding

tresB — Thu, 07 Apr 2016 10:14:23 GMT

=If(GetSelectedCount([Salesman ID]), 'SH02')

However, it seems a bit surprising to me as well. I read somewhere that 'Clear' is caught by only 'OnAnySelect'. May be this behavior has changed in newer versions.

Re: Trigger to next sheet - Regarding

kkkumar82 — Thu, 07 Apr 2016 10:14:38 GMT

Hi Chanty,

Thats what I want similar to yours even after clearing it should not navigate to the original sheet where I kept the navigation.

Can you tweak my file.

Kiran Kumar

Re: Trigger to next sheet - Regarding

Chanty4u — Thu, 07 Apr 2016 10:21:44 GMT

As for ur data i dnt hve reload option..

u can try by creating dummy dimension as i mentioned abve screen shot.....and apply trigger

Re: Trigger to next sheet - Regarding

kkkumar82 — Thu, 07 Apr 2016 10:23:49 GMT

Thanks Gybbert

It worked

Re: Trigger to next sheet - Regarding

kkkumar82 — Thu, 07 Apr 2016 10:25:25 GMT

Is this I Should use If I want to navigate only from Sheet 1 to Sheet 2 Sunny.

Re: Trigger to next sheet - Regarding

sunny_talwar — Thu, 07 Apr 2016 10:27:46 GMT

Yes, this would work only if you want to navigate from a particular sheet

Re: Trigger to next sheet - Regarding

kkkumar82 — Thu, 07 Apr 2016 10:30:19 GMT

Superb ...

thanks Sunny and Gysbert

finally this is what I used

=if(subfield(GetActiveSheetId(),'\',2)='SH01', if(GetSelectedCount([Salesman ID])<>0,'SH02'))

Kiran kumar