topic Re: pre selecting multiple year in a sheet in QlikView

pre selecting multiple year in a sheet

Anonymous — Tue, 30 Jun 2015 12:09:34 GMT

Hi Guys,

I have multiple sheets. I have created a trigger that selects the latest year whenever a user clicks on a sheet.

However if this user selects multiple year, and goes back to that sheet, he still sees the latest year.

My question: how configure that a sheet is by default the latest year and if a user selects other years, QV holds these values.

Thanks!

Sam

Re: pre selecting multiple year in a sheet

sunny_talwar — Tue, 30 Jun 2015 12:12:57 GMT

May be use a if statement in your trigger:

If(GetSelectedCount(Year) < 2, Max({1}Year))

Re: pre selecting multiple year in a sheet

avinashelite — Tue, 30 Jun 2015 12:19:41 GMT

to handle this you need to follow a two step process.

while setting the trigger you need to count the year selection made and set the variable using

on changes event and then in

on select you need to set the field value as well as the variable (setting the variable again is also important here ). Finally using the variable count you can set the field trigger

Re: pre selecting multiple year in a sheet

ankit777 — Tue, 30 Jun 2015 12:22:43 GMT

May be set the trigger value like this:

if(getselectedcount(Year)=0,Max(Year))

Re: pre selecting multiple year in a sheet

maxgro — Tue, 30 Jun 2015 12:29:24 GMT

trigger should be (y is the year field)

=If(GetSelectedCount(y) = 0, Max({1}y), '(' & Concat(DISTINCT y, '|') & ')')

Re: pre selecting multiple year in a sheet

Anonymous — Tue, 30 Jun 2015 12:41:11 GMT

It's not working.

This is what I have now on one sheet:

field Year

search =max(Year)

but If I go to the next sheet and select more than 1 year and go back to my first sheet, the max year is selected.

Re: pre selecting multiple year in a sheet

sunny_talwar — Tue, 30 Jun 2015 12:42:58 GMT

Try Massimo Grossi‌ solution and see if that works. If not, would you be able to share a sample?

Re: pre selecting multiple year in a sheet

buzzy996 — Tue, 30 Jun 2015 12:45:17 GMT

try to use tis macro on ur document with triggers and see.

sub On_Load

ActiveDocument.ClearAll

ActiveDocument.Fields("Year").Select Year(Now())

end sub

Re: pre selecting multiple year in a sheet

maxgro — Tue, 30 Jun 2015 12:52:29 GMT

trigger in sheet6