topic Re: Variable in Trigger in QlikView

Variable in Trigger

QFanatic — Sat, 16 Nov 2024 18:51:24 GMT

I have a model that contains a field called Date (that displays YYYYMMDD but us a true date field)

In the on Open Event I want only the last 3 days to be selected, by default.

I have created a variable, vOpenDate, that contains =date(max(DATE) - 3)

how do I implement this in the On Open trigger ? I'm not sure of the syntax...

Thanks

tresB — Wed, 01 Apr 2020 11:06:37 GMT

You can use the below search expression:

='>'&Date(Max(DATE)-3, 'YYYYMMDD')

NitinK7 — Wed, 01 Apr 2020 12:45:41 GMT

you need to create daterange for the same

1. need to create two variable for max date and maxdate-2 see below screenshot

2.go to setting -->Document properties-->trigget-->onopen-->add action-->select field

then set your field and write search string like below

='>='&vEnddate&'<='&vStartdate

see below screenshot

Thanks,

Nitin.