QlikView Slider

[#1]

Hi,

I have data that looks somewhat like this:

I need to create slider in the way when you click on one specific invoice (and as you see invoice# may repeat but have different amount and date) slider should show the earliest invoice date plus 7 consecutive days.

So if I click on invoice on invoice 11a, first date on the slider should be 1/1/2015, then 1/2/2015, 1/3/2015, 1/4/2015, 1/5/2015, 1/6/2015, 1/7/2015. so this way when I move that slider to show only 1/1/2015 to 1/3/2015 only one invoice 11a is only one show up. But when I move slider to show 1/1/2015 to 1/7/2015 it will show two 11a invoices.

Any ideas?

[settu_periasamy · Accepted solution]

Hi,

Check the attachment. May be helpful.

[#3]

Hi Settu,

Could you please tell me what does 402005 in vMin variable represent?

Thank you-

[settu_periasamy]

Hi,

That is the number format of minimum date. It should be 5 digit.

Are you sure it is 402005 or 42005?

[settu_periasamy]

Is that worked expected?

[#6]

Hi Settu,

My dates do not look as actual dates.

[jonathandienst]

These two articles will help you:

QlikView Date fields

Why don’t my dates work?

[#8]

Thank you Settu and Jonathan, I got this one to work!