topic Re: QlikView Slider in QlikView

QlikView Slider

Fri, 20 Nov 2020 18:02:30 GMT

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?

Re: QlikView Slider

settu_periasamy — Fri, 14 Aug 2015 06:48:48 GMT

Hi,

Check the attachment. May be helpful.

Re: QlikView Slider

Fri, 14 Aug 2015 16:19:56 GMT

Hi Settu,

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

Thank you-

Re: QlikView Slider

settu_periasamy — Fri, 14 Aug 2015 17:48:44 GMT

Hi,

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

Are you sure it is 402005 or 42005?

Re: QlikView Slider

settu_periasamy — Fri, 14 Aug 2015 17:50:00 GMT

Is that worked expected?

Re: QlikView Slider

Mon, 17 Aug 2015 03:25:45 GMT

Hi Settu,

My dates do not look as actual dates.

Re: QlikView Slider

jonathandienst — Mon, 17 Aug 2015 06:11:22 GMT

These two articles will help you:

QlikView Date fields

Why don’t my dates work?

Re: QlikView Slider

Mon, 17 Aug 2015 17:16:48 GMT

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