topic Re: order by not working in QlikView

order by not working

rahulhv1 — Fri, 05 Dec 2014 09:55:21 GMT

Hi gurus,

below is the simple code I am having

TAB1:

load NO, NAME,MARKS FROM D:\TRIAL.XLS (ooxml,embedded labels, table is Sheet1);

Noconcatenate

ABC1:

Load NO, NAME,MARKS resident TAB1 Order by NAME;

drop table TAB1;

In result I found that Order by clause do not work. I have tried different combinations i.e. NO , NUM(NO) , NAME but it doesn't work.

Pls. suggest me the solution

Re: order by not working

alexandros17 — Fri, 05 Dec 2014 09:56:54 GMT

It should work, could you please send the reult?

Re: order by not working

marcus_malinow — Fri, 05 Dec 2014 10:06:13 GMT

Try adding 'RowNo() as RowNumber' to your ABC1 load to confirm that it's not working.

You could also try t create a chart using your sorted dimension, and sort by Load Order.

If you still have an issue could you post some of the affected data?

Re: order by not working

Fri, 05 Dec 2014 10:10:30 GMT

The order shoudl work fine, maybe try to specify the ordering you want

Order By NAME asc

for example

hope that helps

Joe

Re: order by not working

alexandros17 — Fri, 05 Dec 2014 10:12:26 GMT

maybe there are leading or trailing charachters ... try with trim(NAME)

Re: order by not working

rahulhv1 — Fri, 05 Dec 2014 10:21:23 GMT

how to attach document in reply?

Re: order by not working

rajeshvaswani77 — Fri, 05 Dec 2014 10:30:41 GMT

Hi,

Did you drop tab1?

thanks,

Rajesh Vaswa

Re: order by not working

Fri, 05 Dec 2014 10:32:19 GMT

Its working ... just check it out once

ABC1:
Load NO,Name,Marks,RecNo() as Count

Resident TAB1

Order by NO desc; // order by asc either of them will work

Re: order by not working

its_anandrjs — Fri, 05 Dec 2014 10:44:48 GMT

Try this way also

It is working try to click on Ctrl + T and see the difference.

1. Once load without the order table and see Ctrl + T.

2. Then add the Order table and then see Ctrl + T

You seethere is order by try to load data in the table with sorted order

Or you can do by adding RecNo() as Rec or RowNo() as Rowid

NoConcatenate

ABC1:

LOAD NO,NAME,MARKS,RecNo() as Rec Resident TAB1 Order BY NAME;

DROP TABLE TAB1;

Regards

Anand

Re: order by not working

rahulhv1 — Fri, 05 Dec 2014 11:50:53 GMT

even this is not working. have u seen my qvw & xls file that I have attached?

Re: order by not working

Fri, 05 Dec 2014 11:53:24 GMT

what attachments.....?

Re: order by not working

rajeshvaswani77 — Fri, 05 Dec 2014 11:54:37 GMT

Can you please attach an example?

thanks,

Rajesh Vaswani

Re: order by not working

martin_dideriks — Fri, 05 Dec 2014 12:18:10 GMT

First question: Why do you want to do a resident load of a table?

Though I have not tried a solution myself, I will guess it should work, if you rename your fields in the resident load.

The reason, that you see this behaviour, is that you have already loaded the fields NO, NAME,MARKS into the datamodel in TAB1. When you load the same tables in ABC1, the fields will be sorted just as in TAB1.

Ie. If you load a table like this:

LOAD * INLINE [

FieldA

];

The following data loaded into QV, will be sorted just like FieldA (providing FieldA) exists in that table.

Re: order by not working

its_anandrjs — Fri, 05 Dec 2014 12:32:49 GMT

Try this way and make this settings in the table box remove all sort settings in the properties and use only load order after order by for all fields and also try to load like in this sequence Name,No,Marks.

TAB1:

LOAD

NAME,

NO,

MARKS

FROM

TRIAL.xlsx

(ooxml, embedded labels, table is Sheet1);

NoConcatenate

ABC1:

LOAD NAME,NO,MARKS,RecNo() as Rec Resident TAB1 Order BY NAME;

DROP TABLE TAB1;

Regards

Anand