Qlik Community

Qlik Sense App Development

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

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Partner
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

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.

View solution in original post

2 Replies
Chanty4u
Esteemed Contributor III

Re: Strange behaviour of date function ??

No. try below

single quotes

fr.PNG

='$(=date(42620))'

Highlighted

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.

View solution in original post