Discussion board where members can get started with QlikView.
i have two columns of date
i want to show shelf life as b-a = 365
what should i do?
Go to Solution.
View solution in original post
1:LOAD * INLINE [a, b13/7/2017, 13/7/2018];
NoConcatenate2:Load *, date#(b,'DD/MM/YYYY')-date#(a,'DD/MM/YYYY') as shelf Resident 1; DROP table 1;
i tried your solution but now its not showing me as 365 output in 3rd column.
provided solution must work. can you describe what are the steps you are trying? where are you trying?
post your script and chart expression
Remove the date format for the result column. 30/12/1900 is the date representation of the number 365.
yes it worked thanx