how can i create a n days ago filter in qilksense

[hinawalia]

I have a date field. I created various variable for 7 days ago, 30days ago and 60 days ago which give me that specific date . Now, i want one filter where a user can select any specific n days ago, and the data in dashboard change according to that date criteria.

say if use select 7 days ago, then all data in dashboard reflect to the criteria where date column>7 days ago.

How can i accomplish this.

Thanks

Hina.

[gomeri]

Hello @hinawalia , 

I hope to understood your request correctly.

You need to have a if control that goes to act on a field with the date values.

You can create a variable to insert into action of a button. When your user click on the button acts the expression inserted into you variable.

For example, you need to create a Call to Action that allows you to move to 7 days earlier than the date.

For do this you need to create a variable where insert set expression that deviates to 7 days from the given date, and then add this variable to your button.

Is my reasoning correct? Let me know.

Thank you