topic Re: DATEDIFF in QlikView

DATEDIFF

Fri, 27 Mar 2015 18:57:56 GMT

I am new to QuikSense and just starting to evaluate it as a BI tool. I downloaded the free version and am trying to do a simple calculation with DATEDIFF, but get a "not a valid function" error when I attempt to upload the data. I am a SQL novice so there may be an error in my script (below). How in depth a knowledge of SQL does a user need have to develop useful, relevant apps? Where can I find a resource for functions built-in to QlikSense?

DATEDIFF(DD,admit_dt_ts, GETDATE()) as [LOS],

Thanks.

Re: DATEDIFF

MK_QSL — Sat, 28 Mar 2015 14:22:38 GMT

Interval(now() - admit_dt_ts,'DD') as LOS

Re: DATEDIFF

Ralf-Narfeldt — Mon, 30 Mar 2015 05:18:37 GMT

DateDiff() is not a valid Qlik Sense function. Manish example should achieve the same.

Here's a link to the reference for Qlik Sense functions:

http://help.qlik.com/sense/en-US/online/#../Subsystems/Hub/Content/Scripting/FunctionsInScriptAndChart.htm

Re: DATEDIFF

sujeetsingh — Mon, 30 Mar 2015 05:28:05 GMT

Interval is a best option and function provided by Qlik.

Re: DATEDIFF

hic — Mon, 30 Mar 2015 05:37:05 GMT

Or simpler,

now() - admit_dt_ts as LOS

Interval() just formats the result into a specified time format. Here you don't need it, since you want it in days and that is what the subtraction returns.

HIC

Re: DATEDIFF

simonaubert — Fri, 19 Feb 2021 18:58:30 GMT

Hello,

Please note you can vote on this idea to implement datediff in Qlik Sense :
https://community.qlik.com/t5/Ideas/New-function-Datediff-to-have-the-difference-between-two-dates/idi-p/1756870

Best regards,

Simon