QlikView Forums & Resources
QlikView Layout & Visualizations
Please enter a title.
You can not post a blank message. Please type your message and try again.
: Aug 1, 2011 4:46 PM by Debbie Pyykkonen
Use Button & Select in Field to filter sheet by date variable
Aug 1, 2011 4:46 PM
I would like the end user to be able to click on a button to filter the select to only those contracts ending in a date range based on filter.
User inputs date in input box and it is store to variable vFCSDate.
User then clicks on a button to filter just those within the date range.
I created a button and used Select in Field action with this code:
=END_DATE >= $(vFCSDate)-30 and END_DATE <= $(vFCSDate)
I am trying to find a way for uer to input an FCS Date and trigger the sheet to filter only to those contracts with end date in the 30 day range before the FCS date.
This content has been marked as final.
Show 0 replies
Remove from profile
Feature on your profile
More Like This
Retrieving data ...