topic Sheet Selection Triggers in QlikView

Sheet Selection Triggers

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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 — Wed, 31 Jan 2018 11:04:04 GMT

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

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

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

jonathandienst — Wed, 31 Jan 2018 11:06:03 GMT

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 — Wed, 31 Jan 2018 11:06:56 GMT

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 — Wed, 31 Jan 2018 11:10:07 GMT

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 — Thu, 01 Feb 2018 06:12:05 GMT

Hi,

Can you please explain in brief.

Thanks..

YoussefBelloum — Thu, 01 Feb 2018 08:55:14 GMT

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