Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
Not applicable

Date in graph (qlik sense)

Hello I'd like to ask. I have data and one column is "date". Even if chagne its type to "timestamp or date" it doesnt work to use it in graph. Funny thing is - sometimes it automaticly recognize that it is date and sometimes it doesnt. I have always same data and same column names. i changed column with dates to "Date" and use "sys_created_on.autoCalendar.Date". It shows what is shows on picture below, which is lie. Dates are like "17.1.2013 21:50:30" Input format is "D.M.YYYY h:mm:ss".

bbbb.png

Thanks for help.

2 Replies
shraddha_g
Not applicable

Re: Date in graph (qlik sense)

Try something like this:

Date(Floor(Date#(datefield, 'd.m.yyyy hh:mm')))

sunny_talwar
Not applicable

Re: Date in graph (qlik sense)

I think it would be helpful for you to read through these blogs:

Why don’t my dates work?

Get the Dates Right