topic Re: Sheet trigger action OnActivateSheet Select In Field in QlikView

Sheet trigger action OnActivateSheet Select In Field

matthewp — Thu, 08 Oct 2015 10:53:32 GMT

I am trying to add an action in a sheet trigger top make a default selection however i cant get it to work.

Field

=YEAR(CREATTION_DATE)

Search String

(2014|2015)

Where am i going wrong?

Re: Sheet trigger action OnActivateSheet Select In Field

SergeyMak — Thu, 08 Oct 2015 11:00:06 GMT

Hi,

You don't have Year field.

Your =YEAR(CREATTION_DATE) is not a field.

So you just have to create it in the load script

Something like

LOAD

Your_fields,

YEAR(CREATTION_DATE) AS Year

FROM ...

Then you will be able to create your trigger.

Regards,

Sergey

Re: Sheet trigger action OnActivateSheet Select In Field

rubenmarin — Thu, 08 Oct 2015 11:03:10 GMT

Hi matthewp, field name can be an expression but it should return the name of the field you want to make selections, and your expression in the best case can return a number.

Maybe this works:

Field

CREATTION_DATE

Search String

(*2014|*2015)

This can work is your CREATTION_DATE format ends with year (YYYY)

Re: Sheet trigger action OnActivateSheet Select In Field

Gabriel — Thu, 08 Oct 2015 11:04:45 GMT

Hi,

Right click on the sheet select properties then under OnActivateSheet select Add Action(s) then select SELECT IN FIELD then in the Field enter Year field and in the Search String enter (YYYY | YYYY) click OK adn OK. See screen print below

Re: Sheet trigger action OnActivateSheet Select In Field

matthewp — Thu, 08 Oct 2015 11:05:57 GMT

I like this method but unfortunately CREATION_DATE is in the format DD/MM/YYYY HH:MM:SS e.g. 28/09/2015 12:05:54

Is there anyway to use that?

Re: Sheet trigger action OnActivateSheet Select In Field

rubenmarin — Thu, 08 Oct 2015 11:10:29 GMT

Search String (*2014*|*2015*) should work... added * after year.

Re: Sheet trigger action OnActivateSheet Select In Field

matthewp — Thu, 08 Oct 2015 11:12:35 GMT

I added YEAR(CREATTION_DATE) AS Year to my load and it has pulled in a working year correctly.

However my trigger is still not working.

Field

=YEAR

Search String

(2014|2015)

Re: Sheet trigger action OnActivateSheet Select In Field

matthewp — Thu, 08 Oct 2015 11:13:43 GMT

Still nothing when using that string

Re: Sheet trigger action OnActivateSheet Select In Field

SergeyMak — Thu, 08 Oct 2015 11:15:12 GMT

Don't use = sign

Just put YEAR as a field

Re: Sheet trigger action OnActivateSheet Select In Field

matthewp — Thu, 08 Oct 2015 11:16:55 GMT

Still not working unfortunately

Re: Sheet trigger action OnActivateSheet Select In Field

maxgro — Thu, 08 Oct 2015 11:17:13 GMT

FIELD

YEAR

not

=YEAR

Re: Sheet trigger action OnActivateSheet Select In Field

rubenmarin — Thu, 08 Oct 2015 11:18:18 GMT

Can you upload a sample? worked for me in one of my documents.

From your answer to Sergey, you created a field 'Year' but you are using field name 'YEAR', field names are case sensitive, so 'Year' and 'YEAR' are different field names.

Re: Sheet trigger action OnActivateSheet Select In Field

SergeyMak — Thu, 08 Oct 2015 11:21:32 GMT

QlikView is case sensitive with field names. SO, if you created field Year, you have to use Year

Re: Sheet trigger action OnActivateSheet Select In Field

matthewp — Thu, 08 Oct 2015 11:22:38 GMT

Case sensitivity was causing my issue!! thank you!