Can I limit the Dimension by a duration of time?

[#1]

I have a chart where the only dimension is the date of a credit return. I'm having the table sort descending by date, which is working fine, the returns are listed in reverse chronological order.

There are a lot of records though, and sometimes it might only be appropriate to show records from the last n days.

In the attached QVW, you'll see that the chart goes back to records made in 2006. How can I limit the date dimension using a length of time? I.E. the last 7 days?

[#2]

Hi

Check the attached one

[#3 · Accepted solution]

Hi,

I think this is what you are looking for

find the attachment

[#4]

Hi, thanks this worked. Could you explain how the expression makes this work? Is that just a short-hand if statement?

Thanks.

[#5]

This is because of setanalysis

This is just like Sql query with where clause