Sheet Selection Triggers

[nareshthavidishetty]

Hi,

We have sheet trigger by making max(year) as Select in field Action for one sheet.

Now when we navigate to that shhet we have Max(year) was selected.

Here when we moved to next sheet the same max(year) is selected by default.

But the user no need to max(year) selection in other sheets.

For that we have create another action like clear field action( Field=Year) while leaving the sheet.

Here is the issue.

If the user makes a year selection other that max(year) and then if he moved to next sheet the selction is cleard.

But i need to capture the ramdom year seletions and aslo when ever he moved back to the sheet it should show max(year).

Thanks..

[jonathandienst]

Use set analysis rather than sheet triggers to have the best user experience and performance.

For the sheet needing max(year), add the set expression (bold) to the expressions on the sheet:

     Sum({<year = {"$(=Max(year))"}>} amount)       // to allow max(year) to follow selections

     or

     Sum({1<year = {"$(=Max(year))"}>} amount)     // to ignore all selections

For the other sheet(s), omit that set expression.

[jonathandienst]

It may also be necessary to override other date selections on the first sheet, especially for the second suggestion, like:

    Sum({1<year = {"$(=Max(year))"}, MonthYear>} amount)   // to prevent a selection in MonthYear from interfering

[kaushiknsolanki]

You can do one thing.

Create a variable which stores the Year Selected.

Now in next sheet trigger, after clear selection, you can make selection in year field as per the value available in variable.

This way your selections can be moved to other sheet.

No need to change any thing in 1st Sheet where you want to show Max(year)

Regards,

Kaushik Solanki

[nareshthavidishetty]

Hi,

I belive with logic posted we can't do a comparision between 2 years.

Because we have used the max year.

But we need the comapritive analysis as well.

Thanks.

[nareshthavidishetty]

Hi,

Can you please explain in brief.

Thanks..

[YoussefBelloum]

Hi jontydkpi,

can you please explain why did you add MonthYear here on the set analysis when you already have 1 to ignore all other selections ?