Qlik Sense - filter table based on selected date period in filter pane

sjoshan — Thu, 01 Apr 2021 13:46:08 GMT

Hi,

In brief: This is a table of customers and their sales data, along with the date of their 1st order and the date of their last order. Pls see the image.

I have to find the new customers that have been acquired on a quarterly basis. Since all the customers do repeat business, we need to remove those who placed their first orders with us in a period earlier than what has been chosen in the filter pane.

I have a single data field in my data source - SB_Date.

On the sheet, I have a filter pane' with dimension = SB_Date.autoCalendar.YearQuarter

When I choose date periods (in YYYY-Qtr) from the filter pane, I get a listing of records in the chosen date period.

Further, there are 2 more columns in the table which are calculated as follows:

Started (the date of 1st order) = Min({$<[SB_Date.autoCalendar.YearQuarter]=>}SB_Date)

Last order = Max({$<[SB_Date.autoCalendar.YearQuarter]=>}SB_Date)

Now what I need help with is - that based on the filter pane date period selections, only those rows should appear in the table where:

Started (the date of 1st order) = selected date periods from the filter pane (SB_Date.autoCalendar.YearQuarter)
Wherever the Started <> Selected date period, the rows should not appear.

Please help!

Thanks

topic Qlik Sense - filter table based on selected date period in filter pane in App Development

Qlik Sense - filter table based on selected date period in filter pane