topic Re: Acceding order !!!!! in QlikView

Acceding order !!!!!

Mon, 19 May 2014 11:59:53 GMT

Hi All,

How to Sort the data in Scripting level

If suppose i have salary column in my table i calculated Tax based an the column in script itself i need the sort the Tax Column in Acceding order how we can do

can u suggest me

Thank u

Re: Acceding order !!!!!

hic — Mon, 19 May 2014 12:05:53 GMT

The structure of the Load should be

Load ... Resident ... Order By Tax Asc ;

The Order By clause cannot be used in a "Load ... From"; it must be a "Load ... Resident".

HIC

Re: Acceding order !!!!!

nizamsha — Mon, 19 May 2014 12:07:46 GMT

while fetching the data from data base use order by

or

if u r getting the data from excel use this code

TempTable:

Load

Name,

Salary,

Amt

from ur table;

no concatenate

TableA:

Load

Name,

Salary,

Amt

Resident TempTable order by Amt;

drop table TempTable;

Because as of i know we cant use order by directly,we can use order by in resident only