topic Re: Trigger in tab in QlikView

Trigger in tab

Wed, 25 Nov 2020 16:16:04 GMT

I have this where clause in the script,

where NOT ( [Subspace Expire] < today() ) AND [Subspace Commence] <= addmonths(today(),12);

Instead of this where clause in the script can I put this as trigger in tab as I need to create another tab with the below trigger,instead of 12 months I have to put 36 months.

where NOT ( [Subspace Expire] < today() ) AND [Subspace Commence] <= addmonths(today(),36);

How can I do that ?

Re: Trigger in tab

sunny_talwar — Wed, 30 Mar 2016 01:40:43 GMT

Are you wanting to replace Where with front end trigger?

Re: Trigger in tab

Wed, 30 Mar 2016 01:47:30 GMT

Ya...

Re: Trigger in tab

sunny_talwar — Wed, 30 Mar 2016 01:53:28 GMT

So I think you would need two select in field actions.

1) Subspace expire

='>=' & Date(Min([Subspace expire]), 'Subspace_expire_Field_Format') & '<' & Date(Today(), 'Subspace_expire_Field_Format')

2) Subspace commence:

='<=' & Date(AddYears(Today(), 3), 'Subspace_expire_Field_Format')

Re: Trigger in tab

Wed, 30 Mar 2016 02:45:16 GMT

Awesome....Thank you very much.