topic Re: Filter table data for previous weeks in App Development

Filter table data for previous weeks

Anony — Mon, 29 May 2023 08:42:42 GMT

Hi All,

We have requirement in qlik sense where we need to add week filter to table .

Table:

Dimension

Metrics1

Metrics2

Metrics 3

Metrics4

Expectation is to add week filter (Week 1, week2, etc) to above table data using which we can select weekly data for past 5 weeks based on date selected.

can anyone help with solution

Re: Filter table data for previous weeks

njmaehler — Mon, 29 May 2023 15:34:39 GMT

What does your date / calendar table look like?
Do you have a field called Week Number or Week End date, etc.?

Re: Filter table data for previous weeks

Anony — Mon, 29 May 2023 15:52:01 GMT

date field is in the format 'M/DD/YYYY'

Re: Filter table data for previous weeks

Anony — Mon, 29 May 2023 15:52:10 GMT

date field is in the format M/DD/YYYY