Show only data from the past 7 days

[#1]

I want to show data from the past 7 days only.

I currently have

sum({<Date={">=$(WeekStart( Today()-7))<$(=today()))"},[Customer] = >}

date([Paid in full date])

-

date([Invoice date])

) / Count( {<Date={'>=$(WeekStart( Today()-7))'},[Customer] = >}Count)

But the above literally does nothing, its the same as if I didn't put in the time parameters. I tried testing the bottom  count(Count)

part to see if my date limitations even worked, and even just the bottom part doesn't change (17 records normally, still 17 after putting the limitation on).

Any ideas?

As you can see, the Average days to pay is the same in both scenarios. The top chart doesn't have the date limitations in the set expression.

[#2]

Thank you! I was confused because Qlik also has a date function, so I thought that is why you put Date there, but I guess not.

[Kushal_Chawda]

This is what I wanted to tell you, but my bad

[#4]

No worries, thank you