Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
sunny_talwar

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
sunny_talwar

Are you wanting to replace Where with front end trigger?

Not applicable
Author

Ya...

sunny_talwar

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

Not applicable
Author

Awesome....Thank you very much.