Sort Line Chart by Timestamp Dimension

[#1]

Hello,

Thanks for looking at and reading my question.

I have created a line chart that has x-axis value as timestamp format. I already tried the following option however its not sorting properly.

I want the data to be sorted till minute precision.

Properties -> Sort -> Expression ->

//date(BEGIN_INTERVAL_TIME,'DD/MM/YYYY hh:mi')

//BEGIN_INTERVAL_TIME

//=num(date(BEGIN_INTERVAL_TIME,'DD/MM/YYYY hh:mi'))

//(Date(Date#(Left([BEGIN_INTERVAL_TIME],10),'MM/DD/YYYY'),'MM/DD/YYYY'))

//Time#(BEGIN_INTERVAL_TIME,'DD/MM/YYYY hh:mi')

//time(frac(BEGIN_INTERVAL_TIME))

Please suggest what should I use to get the correct sort order.

Regards,

[#2]

Did you try this:

Properties -> Sort -> Select your dimension on Xaxis

then enable numericvalue

hope it may help......

[#3]

doesn't help.

[tresesco]

Could you upload sample qvw here?

[#5]

Hi,

Can you upload a sample qvw file.

[#6]

Thanks a lot for replying to my question.

I cannot load my qvw file as its a secure data. Is there any other option for you to tell me, how to sort?

Regards,

[tresesco]

Could be told, but would be hypothetical without seeing your data format. See : Preparing examples for Upload - Reduction and D... | Qlik Community

[rwunderlich · Accepted solution]

It sounds like you have not loaded the BEGIN_INTERVAL_TIME as a proper timestamp value.

Try to parse it in the load like:

timestamp(timestamp#(BEGIN_INTERVAL_TIME, 'MM/DD/YY hh:mm:ss')) as BEGIN_INTERVAL_TIME

adjust the format pattern to match your input. Then you should be able to sort the dimension by Numeric value as Saranya suggested

-Rob

[#9]

Thanks a lot Rob for your time and reply.

I will try it and get back.

Regards,

[#10]

Didn't help. After that its not showing the graph at all.