Getting Latest 7 dates

[Anonymous]

Hi,

I have a start_date column, and i have start_date for 1 year..

eg:

start_date

20/09/2016

I need to get the latest 7 dates from the start_date in a slider object like (20/09/2016)

Help me to find out..

Thanks..

[neelamsaroha157]

you can create two variable...as you already have one variable for Start date, create one more for End Date

as StartDateVariable+7. and then use these two variables in the slider as Min and Max Value.

[rubenmarin]

Hi kishore, you can create two variables:

- vMaxDate with value "=start_date"

- vSelectedDate

Then you can configure the slider like this image:

Note that in the 'Number' tab you can select date as format but the value stored in vSelectedDate will be stored as number

[Anonymous]

Is the mode single value or multi value. what i have to select in variables?

[Anonymous]

i tried. its not working.. m not getting anything in the slider

[Anonymous]

Thank you. i got it.. I had some date format issue.. i solved now.

[Anonymous]

My changes in slider is not reflecting in the charts and tables i have created.. What will be the issue.?

[neelamsaroha157]

can you share some sample

And check out the date formats.

[rubenmarin]

Hi kishore, you should use the vSelectedDate variable in your expressions, in set analisys if possible, ie:

Sum({<Date={'$(=Date(vSelectedDate))'}>} Sales) // this filters the sales where Date equals the date selected in the slider