Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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