Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
bertrand_herard
Not applicable

Strange behaviour of date function ??

Hello,

in (at least) QlikView 11.2 SR 9 x64, In any QlikView application (even a new one), Can someone explain me  why :

in an expression, if you put =date(42620), you will get 07/09/2016 (that is normal).

BUT if you put =$(=date(42620)), you will 0,0003858024691358   ??

Where does come this decimal number ? I thought the date function transforms a number of days into

a date ?

Best regards

1 Solution

Accepted Solutions
sunny_talwar
Not applicable

Re: Strange behaviour of date function ??

Dollar sign expansion is taking the date and converting it into a division calculation

=$(=Date(42620)) -> $(=07/09/2016) -> which is saying 7 divided by 9 divided by 2016.

2 Replies
Chanty4u
Not applicable

Re: Strange behaviour of date function ??

No. try below

single quotes

fr.PNG

='$(=date(42620))'

sunny_talwar
Not applicable

Re: Strange behaviour of date function ??

Dollar sign expansion is taking the date and converting it into a division calculation

=$(=Date(42620)) -> $(=07/09/2016) -> which is saying 7 divided by 9 divided by 2016.