topic How to use order by in SQL in QlikView

How to use order by in SQL

Thu, 01 Mar 2012 15:51:15 GMT

Hi,

I want to sort data in SQL using ORDER BY, but the formula is not working for some reason...

This is how i did it:

Load

// "No_" as DocumentNo

"Document No_"&'-'&"No_" as DocuItemNo

, "Sell-to Customer No_"as CustomerNo

, "Package Tracking No_" as PackageTrackingNo

, "Promotion Name" as PromotionName

, "Promotion ID" as PromotionID

, "Discount Description" as DiscountDescription

;

SQL SELECT

"Document No_"

, "Sell-to Customer No_"

, "No_"

, "Package Tracking No_"

, "Promotion Name"

, "Promotion ID"

, "Discount Description"

FROM "$(DB_DATASOURCE)".dbo."$(DB_COMPANY)$Sales Invoice Line";

ORDER BY "Sell-to Customer No_";

Can anyone tell me what i'm doing wrong?

Thanks,

Eline

How to use order by in SQL

Thu, 01 Mar 2012 16:39:41 GMT

Did you try removing the semicolon after your from statement?

e.g. FROM "$(DB_DATASOURCE)".dbo."$(DB_COMPANY)$Sales Invoice Line";

That clears up the error for me.

How to use order by in SQL

CELAMBARASAN — Fri, 02 Mar 2012 04:43:41 GMT

Hi,

I think semicolon is your problem which you placed the order by clause after the semicolon.

If you are not clear then execute the query used here in the database whether you getting results in order.

SQL SELECT

"Document No_"

, "Sell-to Customer No_"

, "No_"

, "Package Tracking No_"

, "Promotion Name"

, "Promotion ID"

, "Discount Description"

FROM "$(DB_DATASOURCE)".dbo."$(DB_COMPANY)$Sales Invoice Line"

ORDER BY "Sell-to Customer No_";

Celambarasan

How to use order by in SQL

jagan — Fri, 02 Mar 2012 05:55:25 GMT

Hi,

The semicolor may be the issue. Try this

SELECT

"Document No_"

, "Sell-to Customer No_"

, "No_"

, "Package Tracking No_"

, "Promotion Name"

, "Promotion ID"

, "Discount Description"

FROM "$(DB_DATASOURCE)".dbo."$(DB_COMPANY)$Sales Invoice Line"

ORDER BY "Sell-to Customer No_";

Still if you got the error try hardcoding the DataSource and Database name and check whether this is the issue.

Hope this helps you.

Regards,

Jagan.

How to use order by in SQL

Fri, 02 Mar 2012 12:57:12 GMT

Thanks everyone, the semicolon was indeed the problem.