Qlik Community

Qlik Sense App Development

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

BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
New Contributor III

How to properly convert DateTime into Date for line graph.

I am experiencing something very odd. I have a value called "CreateDate" This value is a DateTime. On my table I am not having any issues at all using Date(CreateDate) to show the value as a Date and not Date Time. the issue comes from my line graph where I am trying to create a trend line for created reports. I am using CreateDate on X axis and hoping to give a Count(Tickets) for the Y axis. My problem is even with Date(CreateDate) as my Dimension, it is still splitting up my XAxis into Times and not just Days as I am trying for. Please See attached.

If anyone knows why this is happening I would love some feedback. The basis of this is to create a trend line of Reports created per Day value and not minute.


Labels (3)
1 Reply

Re: How to properly convert DateTime into Date for line graph.

Qlik will split into Date and Time in the diagonal If there is space concern. May be do format with needed?

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)