topic Re: Apply logic to button in QlikView

Apply logic to button

cbaqir — Tue, 15 Sep 2015 21:44:11 GMT

I have a field called ACTIVITY_CODE and a field called ACTIVITY_END_DATE.

I also have button called 'Active Financial View' in which a bookmark is applied. In addition to the bookmark, I want the data to display for ACTIVITY_CODE in which ACTIVITY_END_DATE>=today(). How can I apply this logic to this button?

Thanks,

Cassandra

Re: Apply logic to button

sunny_talwar — Tue, 15 Sep 2015 21:47:33 GMT

May be use a select in field action where you set ACTIVITY_END_DATE with a search string:

='>=' & Date(Today(), 'YourDateFieldFormatHere')

Re: Apply logic to button

cbaqir — Tue, 15 Sep 2015 21:49:35 GMT

Thanks!

Re: Apply logic to button

sunny_talwar — Tue, 15 Sep 2015 21:50:44 GMT

No problem

I am glad I was able to help.

Best,

Sunny