Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anony
Contributor II
Contributor II

Filter table data for previous weeks

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

Labels (1)
3 Replies
njmaehler
Partner - Creator
Partner - Creator

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

Anony
Contributor II
Contributor II
Author

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

Anony
Contributor II
Contributor II
Author

date field is in the format M/DD/YYYY