Qlik Sense App Development

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner

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
Highlighted
MVP

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
Esteemed Contributor III

Re: Strange behaviour of date function ??

No. try below

single quotes

='\$(=date(42620))'

Highlighted
MVP

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.