topic Filtering Data by Fixed Values in QlikView

Filtering Data by Fixed Values

Mon, 18 Apr 2011 16:03:58 GMT

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

Filtering Data by Fixed Values

rbecher — Mon, 18 Apr 2011 16:39:17 GMT

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