Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Not applicable

Sorting Issue

Hello,

We were trying to create a chart that displays hours from today 4AM(Day) to next day 9AM(Day+1). We were taking a inline table to load this

Time_Zone:
LOAD * INLINE [
Time, date_gateCount
05:00, Day
06:00, Day
07:00, Day
08:00, Day
09:00, Day
10:00, Day
11:00, Day
12:00, Day
13:00, Day
...
07:00, Day+1
08:00, Day+1
09:00, Day+1
  ]
;

However we are using the match() function but the chart is not coming properly accordingly time 4AM to 9AM.I think there is a sorting issue between these two fields date_gateCount and Time.

Kindly suggest.

Regards,

Aneesha

Tags (1)
3 Replies

Re: Sorting Issue

What is your sort expression?

Re: Sorting Issue

please post a sample application to demonstrate.

Not applicable

Re: Sorting Issue

sort expression.PNG