Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Our next Qlik Insider session will cover new key capabilities. Join us August 11th REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
kishorepanduran
Creator III
Creator III

Getting Latest 7 dates

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..

8 Replies
neelamsaroha157
Specialist II
Specialist II

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:

test.png

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

kishorepanduran
Creator III
Creator III
Author

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

kishorepanduran
Creator III
Creator III
Author

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

kishorepanduran
Creator III
Creator III
Author

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

kishorepanduran
Creator III
Creator III
Author

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

neelamsaroha157
Specialist II
Specialist II

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