Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I will try to use he Vizlib calender in a small Sense app.
However the current dateformat doesn't seem to work in the Calender (see table below)
According to the Calender documentation i need to do this:
needs to have the $timestamp metadata tag assign to it by the Qlik Sense data model.
How do I do this?
It is important that the field in question is really interpreted when being loaded as an actual date. Then it will automatically get the $timestamp tag assigned to it.
Date#( yourDate, 'YYYY-MM-DD hh:mm:ss') AS yourDate
is a way of ensuring that Qlik Sense convert yourDate in a special format to an actual date within the data model.
Hi!
I added: Date#([wor_event_start_time],'YYYY-MM-DD') as Date, in the LOAD script.
The result looks strange (see screenshot below).
I want to use date in the filter 'YYYY-MM-DD'. Using the current timestamp (wor_event_start_time) will not work
Hi,
Put Date() in front of your current expression try below
Date(Date#([wor_event_start_time],'YYYY-MM-DD'),'YYYY-MM-DD hh:mm:ss') as Date
Regards,
Yes - sometimes you have to be very explicit to get it all right
Hi!
Doesn't work.
When using your suggested expression the 'Date' is empty
Hi Stefan,
Try this:
Date(Floor([wor_event_start_time])) as Date...
Hi!
This solved my problem.
Thank You