Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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.
Tags (3)
Community Browser