topic Triggers in QlikView

Triggers

vijetas42 — Tue, 22 Sep 2015 12:38:26 GMT

Hi All,

We have one requirement that,i am having 2 sheets in first sheet i have brand as selection.when i go to second sheet it will clear brand and when i come back on first sheet it should show me previous selected brand value.Can anybody help me with how to achieve this.

Regards,

Vijeta

Re: Triggers

Anonymous — Tue, 22 Sep 2015 12:40:59 GMT

save last selected brand in a variable

whenyou go back to this sheet provide a Trigger with select field

and Expression =yourvariable (or =$(yourvariable)

Re: Triggers

lironbaram — Tue, 22 Sep 2015 12:46:15 GMT

first of all , for me i sounds very confusing for the user

as a rule of thumb i try not to use triggers

but for your case you can do this

when leaving the sheet

1.assign the selections in brand to variable

2. clear brand field

when entering the first sheet

1. select in the brand field the value of the variable

Re: Triggers

vijetas42 — Tue, 22 Sep 2015 13:06:17 GMT

Hi,

I have crated 1 variable like,vBrand and taken value as getfielseletcion(Brand)

when I go to second sheet I am clearing field Brand

and on first sheet i have applied trigger like,Select in Field where Filed as Brand and value as =$(vBrand)

but it's not working.

Re: Triggers

Anonymous — Tue, 22 Sep 2015 13:13:46 GMT

the Problem is that you defined getfieldselections(Brand)

and after you clear the brand

so variable contains no value

maybe you could define your variable as

if (getselectedcount(brand)>0, getfieldselection(Brand)); so in your case (you select a brand, the brand is stored in variable, you Change the sheet, clear brand and go back to previous sheet, variable should contain the last brand)

Re: Triggers

vijetas42 — Tue, 22 Sep 2015 13:23:25 GMT

Hi,

This is also not working,when i come back on first sheet it's clearing all Brands,any other way to achieve the same.

Re: Triggers

Anonymous — Tue, 22 Sep 2015 13:35:44 GMT

my fault

Definition of "yourvariable"

I forgot else part

=if (GetSelectedCount(FilialNummer)>0, GetFieldSelections(FilialNummer),yourvariable)

I tested it in my app with the trigger select field yourfield and Expression =yourvariable

Re: Triggers

vijetas42 — Tue, 22 Sep 2015 14:00:59 GMT

Hi,

Yes, It's working fine.Thanks !!!