Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. April 17 - 20, 2023, in Las Vegas! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
sunitha_chellaiah
Partner - Creator
Partner - Creator

Value of Date Variable Coming in Number Format

Dear All,

While using below mentioned expression, value is coming in number date. It should come in Date format.

=$(=Max(DOJ))

I want to use this expression in set analysis. So I am testing this in text object. Kindly see below screenshot.

Value should come as 28-06-2021. But here it is showing -1999.

Please help me to correct the expression.

sunitha_chellaiah_0-1626250619345.png

Thanks in advance.

11 Replies
tresesco
MVP
MVP

Thank you very much HIC for the clarification. 

I also find that in Qlik Sense, 'Auto' format takes the Number format while it is still a dual value. 

sunitha_chellaiah
Partner - Creator
Partner - Creator
Author

Hi @hic ,

I got the correct value now by using this expression.

='$(=Max(DOJ))'

Thank you so much.