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: 
MNicolas
Contributor III
Contributor III

Field format stay in timestamp

Hello all,

I have an issue with one of my field which is in timestamp and I want it in date. I think the format is staying in cache, because in the script I tried to formate to date (floor, date 'DD/MM/YYYY') and I untagged the field with timestamp, I reload a dozen times, but the format is  staying in timestamp untill I rename the field...

MNicolas_0-1588239899034.png

Any idea ?

 

Labels (3)
4 Replies
agigliotti
MVP
MVP

let's try to apply the Floor function in the script.

ex. Floor(your_timestamp_field) as new_Date_Field

I hope it can helps.

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
MNicolas
Contributor III
Contributor III
Author

Thanks but as written in my post I tried :

- floor(myfield)

- date(myfield, 'DD/MM/YYYY')

- untagg my field with timestamp

And the timestamp is still here...

agigliotti
MVP
MVP

but i saw that your time is always equals to 0.
maybe could you simple apply a date format in your table column?

The Power of shining a light on the dark side of your data.
Follow me on my LinkedIn | Know Gamma Informatica at gammainformatica.it
MNicolas
Contributor III
Contributor III
Author

Yes the time is equal to zero cause I use the Floor function ....

I dont want to use it in a table. In the filters I can't formate the date and I dont want it to appears on the selection as a timestamp

I just want to know how I can get rid of the cache