topic Re: shelf life in QlikView

shelf life

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

i have two columns of date

a b

13/7/2017 13/7/2018

i want to show shelf life as b-a = 365

what should i do?

Frank_Hartmann — Mon, 24 Jun 2019 07:22:19 GMT

1:
LOAD * INLINE [
a, b
13/7/2017, 13/7/2018
];

NoConcatenate
2:
Load *, date#(b,'DD/MM/YYYY')-date#(a,'DD/MM/YYYY') as shelf Resident 1; DROP table 1;

PrashantSangle — Mon, 24 Jun 2019 07:27:54 GMT

use
interval(b-a,'D')

Regards,

riishabhz — Mon, 24 Jun 2019 10:00:54 GMT

interval(date#(B,'DD-MM-YYYY')-date#(A,'DD-MM-YYYY'),'D')

i tried your solution but now its not showing me as 365 output in 3rd column.

PrashantSangle — Tue, 25 Jun 2019 04:21:31 GMT

provided solution must work. can you describe what are the steps you are trying? where are you trying?

post your script and chart expression

Regards,

Prashant Sangle

jonathandienst — Tue, 25 Jun 2019 05:12:35 GMT

Remove the date format for the result column. 30/12/1900 is the date representation of the number 365.

riishabhz — Wed, 26 Jun 2019 04:30:48 GMT

yes it worked thanx