Trigger another Sheet on Field selection

[#1]

Hi,

I have an issue with SHEET Trigger.I have a document with multiple Sheets.

I want to Trigger Sheet02 based on the selection of a Field in a Straight Table from Sheet01.However i'm able to do that one.

But the problem is i have the same field used as filter in a Listbox.So if i click any value from Listbox also it's triggering Sheet02.

But i want only if i select any value of the Field from Chart to Trigger the Sheet02.

Any suggestion guys?

Thanks.

[jonathandienst]

Hi

QV can detect that you are making a selection, but it cannot determine how, so there is no difference between making a selection for the same field in either a table or a list box.

You will have to use a different field for one of the two objects.

HTH

Jonathan

[#3]

Thanks Jonathan for the quick reply.

I can't use different field.as the same has to be used as Filter.

Let's see if anything can sort this issue else i have to use two field for the same field.

Thanks.

[jerem1234]

The only other option that I can think of is maybe using alternate states for either the listbox or your chart. I would say your chart, since the listbox probably will affect other charts. Then when you have the trigger, make sure you specify the alternate state you are using. This way you can "have" two triggers for one field. Then put set analysis in your chart like {<Date = $::Date, .... >}.

Hope this helps!

[#5]

Hi Jerem,

I have only one chart using that field Territory ID as one dimension.The same Territory_ID is used as filter in the Listbox.

[Peter_Cammaert]

How about overlaying the Territory_ID column in your chart with a transparant text box that has a sheet trigger. Of course, you will loose the capability to select Territories in your chart, but that's what the list box is for, isn't it?

IMHO there isn't any other feature that restricts a selection and a trigger to just that column in a chart.

Peter

[jerem1234 · Accepted solution]

Please find attached. Had to use variable, then an action for OnChange. Then put the chart as a new alternate state, TriggerState, and left the listbox as default. Then used this for variable, vTransfer:

='(' & concat({TriggerState}distinct [Territory ID], '|') & ')'

Also added a OnLeaveSheet Trigger for the sheet you activated to clear selections in Territory ID for the Trigger State (Clearing selections will also activate the sheet since variable will change).

There is a one small drawback. The variable needs to be used somewhere on the sheet, or else it won't register that it changed (seems like odd behavior for me, but might make sense if the variable contains a formula that needs to be calculated). So what I did was to just put =vTransfer for the Title in Chart and then unchecked Show Title in Chart. Then it will move to other sheet.

If you want to check out the behavior yourself, delete "=vTransfer" out of Title in Chart and then click on a value in chart. It will not move to new sheet. Then put it back in, and it will move.

Hope this helps!

[#8]

Thanks a ton Jerem.Sorry for the late reply.

You banged on the spot man.Though in second sheet i'll not be using Territory field.I was bothered about the filter used in list box which was triggering sheet2 while selecting..which is resolved...