topic Re: Sort Line Chart by Timestamp Dimension in QlikView

Sort Line Chart by Timestamp Dimension

Tue, 01 Jul 2014 04:21:08 GMT

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,

Re: Sort Line Chart by Timestamp Dimension

Tue, 01 Jul 2014 04:28:56 GMT

Did you try this:

Properties -> Sort -> Select your dimension on Xaxis

then enable numericvalue

hope it may help......

Re: Sort Line Chart by Timestamp Dimension

Tue, 01 Jul 2014 04:42:27 GMT

doesn't help.

Re: Sort Line Chart by Timestamp Dimension

tresB — Tue, 01 Jul 2014 04:47:15 GMT

Could you upload sample qvw here?

Re: Sort Line Chart by Timestamp Dimension

Tue, 01 Jul 2014 04:47:28 GMT

Hi,

Can you upload a sample qvw file.

Re: Sort Line Chart by Timestamp Dimension

Tue, 01 Jul 2014 04:53:55 GMT

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,

Re: Sort Line Chart by Timestamp Dimension

tresB — Tue, 01 Jul 2014 04:59:55 GMT

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

Re: Sort Line Chart by Timestamp Dimension

rwunderlich — Tue, 01 Jul 2014 05:01:49 GMT

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

Re: Sort Line Chart by Timestamp Dimension

Tue, 01 Jul 2014 06:07:50 GMT

Thanks a lot Rob for your time and reply.

I will try it and get back.

Regards,

Re: Sort Line Chart by Timestamp Dimension

Tue, 01 Jul 2014 22:16:48 GMT

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

Re: Sort Line Chart by Timestamp Dimension

Wed, 02 Jul 2014 03:52:07 GMT

Thanks for the hint. I tried following to load and its working now.

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