Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

On May 18th at 10AM EDT we will answer your QlikView questions live. REGISTER
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Use Button & Select in Field to filter sheet by date variable

  1. 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.
  2. User inputs date in input box and it is store to variable vFCSDate.
  3. User then clicks on a button to filter just those within the date range.
    1. I created a button and used Select in Field action with this code:
    2. =END_DATE >= $(vFCSDate)-30 and END_DATE <= $(vFCSDate)

  4. 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.
0 Replies