how can i create a n days ago filter in qilksense

hinawalia — Fri, 26 Jul 2024 16:08:30 GMT

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.

Re: how can i create a n days ago filter in qilksense

gomeri — Mon, 29 Jul 2024 12:33:25 GMT

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

topic how can i create a n days ago filter in qilksense in App Development

how can i create a n days ago filter in qilksense

Re: how can i create a n days ago filter in qilksense