Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
zhenjie911
New Contributor III

Remove date timestamp

Hi all,

May i have the way of removing date timestamp from chart?

Capture.PNG

Data is as follow

Capture1.PNG

Data source in excel as follow

Capture2.PNG

7 Replies
Partner
Partner

Re: Remove date timestamp

You can try this either in the Script (recommended) or when using the dimension:

Dimension:

=Date(floor("Date"))

Script:

Date(floor("Date"))        as YourDate

Regards,

Sorin

zhenjie911
New Contributor III

Re: Remove date timestamp

Script is not usable in my environment, as it needs to be used by management. and the solution is also not workable

YoussefBelloum
Esteemed Contributor

Re: Remove date timestamp

Hi

replace your Date dimension with this:

=Date(Timestamp#(Date,'M/DD/YYYY hh:mm TT'))

mikaelsc
Contributor III

Re: Remove date timestamp

remove the continuous axis property (set it to "No")

zhenjie911
New Contributor III

Re: Remove date timestamp

Just as update, none of suggested answer is working. I'm still trying to solve.

Re: Remove date timestamp

can you show us output of your expression after putting it into calculated field..???

Date(Floor(Date),'M/DD/YYYY')

If possible share your sample app.

Regards,

Great dreamer's dreams never fulfilled, they are always transcended.
eduardo_dimperio
Valued Contributor II

Re: Remove date timestamp

Date(Floor(YOUR_FIELD))