topic Date Difference in Chart in QlikView

Date Difference in Chart

thomas_skariah — Thu, 06 Jul 2017 11:53:06 GMT

Hi All,

Can anyone help to provide code for below scenario (refer Date Diff column).

Here I need the date difference of below below date with the above date.

Group	Date	Date Diff
A	1-Jul-17	10.00
A	11-Jul-17	6.00
A	17-Jul-17	2.00
A	19-Jul-17	0.00
B	1-Aug-17	3.00
B	4-Aug-17	9.00
B	13-Aug-17	10.00
B	23-Aug-17	8.00
B	31-Aug-17	0.00
C	1-Jun-17	5.00
C	6-Jun-17	10.00
C	16-Jun-17	3.00
C	19-Jun-17	0.00

Regards,

Tom

Re: Date Difference in Chart

sunny_talwar — Thu, 06 Jul 2017 12:02:11 GMT

Is this something you need in the script or front end chart?

Re: Date Difference in Chart

arvind_patil — Thu, 06 Jul 2017 12:10:05 GMT

Dear Thomas,

you can not look forward you may refer this thread.

Peek next value in the row

Thanks,

Arvind Patil

Re: Date Difference in Chart

prma7799 — Thu, 06 Jul 2017 12:17:56 GMT

Like this?

Re: Date Difference in Chart

Anil_Babu_Samineni — Thu, 06 Jul 2017 12:31:59 GMT

Why every month Last date showing Zero, The user want to close Monthly itself or any other logic ??

Re: Date Difference in Chart

thomas_skariah — Fri, 07 Jul 2017 02:29:44 GMT

Hi Sunny,

I need it at front end, not at back end.

Regards,

Tom

Re: Date Difference in Chart

sunny_talwar — Fri, 07 Jul 2017 02:42:01 GMT

May be this

=Alt(Below(Date) - Date, 0)

Re: Date Difference in Chart

thomas_skariah — Fri, 07 Jul 2017 02:58:23 GMT

Thanks Sunny!!!

Re: Date Difference in Chart

thomas_skariah — Sun, 09 Jul 2017 05:25:30 GMT

Hi Sunny,

By adding an additional column the result shows as zero, chk below screenshot.

A	SSS	1-Jul-17
A	SSS	11-Jul-17
A	SSS	17-Jul-17
A	SSS	19-Jul-17
B	SSS	1-Aug-17
B	SSS	4-Aug-17
B	SSS	13-Aug-17
B	SSS	23-Aug-17
B	SSS	31-Aug-17
C	SSS	1-Jun-17
C	SSS	6-Jun-17
C	SSS	16-Jun-17
C	SSS	19-Jun-17

Regards,

Tom

Re: Date Difference in Chart

sunny_talwar — Sun, 09 Jul 2017 13:11:12 GMT

What is the output you want here? May be try this

=Alt(Below(TOTAL Date) - Date, 0)

Re: Date Difference in Chart

thomas_skariah — Wed, 12 Jul 2017 07:46:03 GMT

Hi Sunny,

Some changes in my logic, so I have created a new thread, can take a look on this.

below is the link

Amount between 2 dates

Regards,

Tom