Filtering Data by Fixed Values

[#1]

I wish to add a slider / drop down control with the values 7,14, 21 and 28.

Upon the user selecting one of theses values the data behind the QVW will be filtered to the last 7 days, the last 14 days, the last 21 days and the last 28 days respectively.

Is this possible and if so how would you do it?

Thank you

[rbecher]

Hi,

you can use a variable with an input box with fixed values which will be displayed as dropdown.

Then, you can use the variable in an set analysis expression like

sum({$<yourDateField={">date(today(1) - $(yourVariable))"}>} Sales)

- Ralf