Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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