Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Specialist II
Specialist II

Re: Getting Latest 7 dates

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.

Highlighted

Re: Getting Latest 7 dates

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

Highlighted
Creator III
Creator III

Re: Getting Latest 7 dates

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

Highlighted
Creator III
Creator III

Re: Getting Latest 7 dates

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

Highlighted
Creator III
Creator III

Re: Getting Latest 7 dates

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

Highlighted
Creator III
Creator III

Re: Getting Latest 7 dates

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

Highlighted
Specialist II
Specialist II

Re: Getting Latest 7 dates

can you share some sample

And check out the date formats.

Highlighted

Re: Getting Latest 7 dates

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