Sorting in Straight Table Pagination

Fri, 16 Aug 2013 01:37:26 GMT

Dear all,

I manage to apply pagination in the straight table. But i realised the first column is not sorted. Any one can help on this? Attach is the file.

Thank you

Re: Sorting in Straight Table Pagination

jagan — Fri, 16 Aug 2013 03:06:02 GMT

Hi,

Use this to sort in script

SET ThousandSep=',';
SET DecimalSep='.';
SET MoneyThousandSep=',';
SET MoneyDecimalSep='.';
SET MoneyFormat='£#,##0.00;-£#,##0.00';
SET TimeFormat='hh:mm:ss';
SET DateFormat='DD/MM/YYYY';
SET TimestampFormat='DD/MM/YYYY hh:mm:ss[.fff]';
SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec';
SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun';

Temp:
LOAD b_LoginID,
     b_FullName,
     b_UserDepartment,
     b_Supervisor,
     b_UserDeptSection,
     b_OrderNumber,
     b_OrderLine,
     b_OrderLinePart,
     b_CustomerName,
     b_BookingTypeDesc,
     b_ProductivityTypeDesc,
     b_BookedTime,
     b_IndirectHours,
     b_DirectHours,
     b_LaborCode,
     b_LaborCodeDesc,
     b_Shift,
     b_JobNo,
     b_StartDate,
     b_EndDate,
     b_StartTime,
     b_EndTime,
     b_OTIndHours,
     b_OTDirHours,
     b_Code,
     b_Absence,
     b_AbsenceHrs,
     b_LastRun,
     b_SinceWhen,
     if(b_SinceWhen='', null(), 1) AS [b_InProcessFlag],
     b_LunchTimeDirect,
     b_LunchTimeIndirect
FROM
DATA\visual-all.txt
(txt, codepage is 1252, embedded labels, delimiter is ';', msq);

Data:
NoConcatenate LOAD
*
RESIDENT Temp
ORDER BY b_CustomerName;

DROP TABLE Temp;

Regards,

Jagan.

topic Re: Sorting in Straight Table Pagination in QlikView

Sorting in Straight Table Pagination

Re: Sorting in Straight Table Pagination