topic Re: Getting Latest 7 dates in QlikView

Getting Latest 7 dates

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

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 — Tue, 20 Sep 2016 12:34:41 GMT

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 — Tue, 20 Sep 2016 12:41:38 GMT

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 — Tue, 20 Sep 2016 12:54:51 GMT

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

Anonymous — Tue, 20 Sep 2016 12:55:14 GMT

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

Anonymous — Tue, 20 Sep 2016 13:01:04 GMT

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

Anonymous — Tue, 20 Sep 2016 13:14:41 GMT

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

neelamsaroha157 — Tue, 20 Sep 2016 13:16:14 GMT

can you share some sample

And check out the date formats.

rubenmarin — Tue, 20 Sep 2016 13:19:48 GMT

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