Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Sorting by Date

Hi,

I need an help for a sorting problem.
The records is composed by lots of timestamp in the format 'DD/MM/YYYY hh:mm:ss[.fff]' called DataAggiornamentoOp.
I want to create a linechart with this dimension

day(timestamp(DataAggiornamentoOp)) &'-'& month(timestamp(DataAggiornamentoOp))&'-'& year(timestamp(DataAggiornamentoOp))

but I can't order the x-axis with the date, because of qlik understand this dimension like a "Text Field".

I can I solve this problem?

1 Solution

Accepted Solutions
ToniKautto
Employee
Employee

If the data is loaded properly as a timestamp, you need to convert the underlying numerical value to a integer. This is done by using the Floor() function on the timestamp.

Date(Floor(DataAggiornamentoOp), 'DD-MM-YYYY')

It is recommended that yo add this as a new field to the data model, so that you only have to prepare the data during reload.

View solution in original post

4 Replies
sunny_talwar

May be change your dimension to this:

Date(Floor(DataAggiornamentoOp), 'DD-MM-YYYY')

Update: Added the Floor based on Toni's response (Thanks Toni for pointing out my mistake)

Not applicable
Author

I try every kind of transformation, but the problem is in the grouping of the linechart. When the timestamp data are aggregated (there is lots of data on a single date), the chart show the result correctly, but the x-axis become a string, and I can't select a correct sorting personalization

ToniKautto
Employee
Employee

If the data is loaded properly as a timestamp, you need to convert the underlying numerical value to a integer. This is done by using the Floor() function on the timestamp.

Date(Floor(DataAggiornamentoOp), 'DD-MM-YYYY')

It is recommended that yo add this as a new field to the data model, so that you only have to prepare the data during reload.

Not applicable
Author

Perfcet, thanks Toni!