topic Re: Trigger not working in QlikView

Trigger not working

nikhilgarg — Tue, 04 Aug 2015 15:02:02 GMT

Hey,

My on activate sheet trigger not working.

I have 2 var: vStart and vEndDate

On activate sheet trigget, i set:

vStartDate: Max(Trans_Date)

vEndDate: Max(Trans_Date)

Then, select in field: TRANS_DATE as: ='>='& date(vStartDate) & '<=' & date(vEndDate)

But when i open the document, i dont get max date selected and corresponding data.

Where am i wrong?

awhitfield — Tue, 04 Aug 2015 15:21:32 GMT

HI Nikhil,

may be you should set the trigger at Document Level as an 'On Open'.

HTH - Andy

nikhilgarg — Tue, 04 Aug 2015 15:23:58 GMT

I tried that also, but still not working.

I have set following triggers:

Set variable: vStartDate

Set Variable: vEndDate

Select In field: Trans_Date

Anonymous — Tue, 04 Aug 2015 15:27:36 GMT

try to use for variable definition

max({1}Trans_Date)

you get max date independant from any selections