Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
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.
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
Is the mode single value or multi value. what i have to select in variables?
i tried. its not working.. m not getting anything in the slider
Thank you. i got it.. I had some date format issue.. i solved now.
My changes in slider is not reflecting in the charts and tables i have created.. What will be the issue.?
can you share some sample
And check out the date formats.
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