Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

Trigger in tab

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 ?


1 Solution

Accepted Solutions

Re: Trigger in tab

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')

View solution in original post

4 Replies

Re: Trigger in tab

Are you wanting to replace Where with front end trigger?

Not applicable

Re: Trigger in tab

Ya...

Re: Trigger in tab

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')

View solution in original post

Not applicable

Re: Trigger in tab

Awesome....Thank you very much.