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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out 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