topic Time sort issue in QlikView

Time sort issue

Thu, 18 Dec 2014 09:48:41 GMT

hi all,

i'm looking for help, for the damn sort time in my chart !! i tried everything, nothing works.

Below, my chart and my script.

thanks

load

DATE_ID,

date(floor(DATE_ID)) as DATES_SHORT,

floor(DATE_ID) as DATES_NUM,

Month(DATE_ID) as Months,

num(Month(DATE_ID)) as MonthNum,

MonthName(DATE_ID) as MonthName,

Year(DATE_ID) as Years,

WeekName(DATE_ID) as Weeks,

WeekName(DATE_ID) as WeekName,

Day(DATE_ID) as Days,

Time(DATE_ID,'HH:mm') as Times,

Hour(DATE_ID) as Hour,

Minute(DATE_ID) as Minutes,

Second(DATE_ID) as Seconds

Resident $(_Table);

Re: Time sort issue

MK_QSL — Thu, 18 Dec 2014 09:50:22 GMT

Change below

Time(DATE_ID,'HH:mm') as Times,

Time(DATE_ID,'hh:mm') as Times,

Re: Time sort issue

tresB — Thu, 18 Dec 2014 09:51:16 GMT

Redefine your time field like:

Time(Frac(DATE_ID),'hh:mm') as Times,

Re: Time sort issue

Thu, 18 Dec 2014 09:51:34 GMT

what the difference Manish ?

Re: Time sort issue

MK_QSL — Thu, 18 Dec 2014 09:53:10 GMT

As tresesco said... true... I missed... use as below

Time(Frac(DATE_ID),'hh:mm') as Times,

Re: Time sort issue

Michiel_QV_Fan — Thu, 18 Dec 2014 10:00:17 GMT

Alternative to formatting the time field:

Order your facts according as needed (date asc, time asc ) and select load order original.

You might need to resident load facts to accomplish this.

Re: Time sort issue

Thu, 18 Dec 2014 10:01:28 GMT

it works well

thanks you gays

Re: Time sort issue

Michiel_QV_Fan — Thu, 18 Dec 2014 10:02:25 GMT

thanks you gays??

That's bad english

thank you guys.....

Re: Time sort issue

Tue, 10 Feb 2015 13:46:12 GMT

oups, sorry