Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Wil18
Contributor II
Contributor II

Convert timestamp to compare

Hello everyone, I would like to have the number of contracts created in 2023. However, the contract creation date ( DateCreation) is in Timestamp format. I have converted

You'll see my code below:

 

Count({$<[Client.statusresil]= {'false'},date#(floor([Client.datecreation]))={"> 31/12/2022"}>} distinct [Client.id_client])

I've tested the above code and it doesn't work. The result is the following capture:

Wil18_0-1696510980759.png

Could you please help me?

Thanks in advance

Have a nice day

Labels (1)
2 Replies
Cascader
Creator
Creator

try:

Count({$<[Client.statusresil]= {'false'},Date(floor(Date#([Client.datecreation])),'DD/MM/YYYY')={"> 31/12/2022"}>} distinct [Client.id_client])

Wil18
Contributor II
Contributor II
Author

I tried but it's  always the same result