Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Load Statement.

How can i change the following Oracle 10g SH schema into Load statement in Qlikview:







Products:

SQL

"PROD_CATEGORY",

"PROD_CATEGORY_DESC",

"PROD_CATEGORY_ID",



"PROD_DESC",

"PROD_EFF_FROM",

"PROD_EFF_TO",

"PROD_ID",

"PROD_LIST_PRICE",

"PROD_MIN_PRICE",

"PROD_NAME",

"PROD_PACK_SIZE",

"PROD_SRC_ID",

"PROD_STATUS",

"PROD_SUBCATEGORY",

"PROD_SUBCATEGORY_DESC",

"PROD_SUBCATEGORY_ID",

"PROD_TOTAL",

"PROD_TOTAL_ID",

"PROD_UNIT_OF_MEASURE",

"PROD_VALID",

"PROD_WEIGHT_CLASS",

"SUPPLIER_ID"

FROM

SH.PRODUCTS; SELECT





1 Solution

Accepted Solutions
adrian_costar
Contributor III
Contributor III

You can use preload statement like in example below:

SALES

load

*,

CANT*PRICE as VALUE;

sql select

PRODUCT,

CANT,

PRICE

from X.SALES;

I hope this is what you are looking for.

View solution in original post

5 Replies
adrian_costar
Contributor III
Contributor III

You have to put SQL in front of select clause.

Products:

SQL select

"PROD_CATEGORY",



"PROD_CATEGORY_DESC",

"PROD_CATEGORY_ID",

"PROD_DESC",



"PROD_EFF_FROM",

"PROD_EFF_TO",

"PROD_ID",

"PROD_LIST_PRICE",



"PROD_MIN_PRICE",

"PROD_NAME",

"PROD_PACK_SIZE",



"PROD_SRC_ID",

"PROD_STATUS",

"PROD_SUBCATEGORY",



"PROD_SUBCATEGORY_DESC",

"PROD_SUBCATEGORY_ID",



"PROD_TOTAL",

"PROD_TOTAL_ID",

"PROD_UNIT_OF_MEASURE",

"PROD_VALID",

"PROD_WEIGHT_CLASS",

"SUPPLIER_ID"

FROM SH.PRODUCTS



Not applicable
Author

Yes you are right, it must have been the typing or cpoy paste problem, but I wanted to know that how should i convert this statement and table in Load statement...

Regards,

Khalid

adrian_costar
Contributor III
Contributor III

You can use preload statement like in example below:

SALES

load

*,

CANT*PRICE as VALUE;

sql select

PRODUCT,

CANT,

PRICE

from X.SALES;

I hope this is what you are looking for.

View solution in original post

Not applicable
Author

Yes thanks, it helped and issue is resolved.

Many thanks,

Khalid

Not applicable
Author

Why this Query is not executing, can you specify any error in it please?







Sales:

Load

"AMOUNT_SOLD"

as "SALE AMOUNT_SOLD",

"CHANNEL_ID"

,

"CUST_ID"

,

"PROD_ID"

,

"PROMO_ID"

,

"QUANTITY_SOLD"

as "SALE QUANTITY_SOLD",

sum

("AMOUNT_SOLD"/"QUANTITY_SOLD" )*100 as "Sales",

"TIME_ID";

SQL

Select

"AMOUNT_SOLD",

"CHANNEL_ID",

"CUST_ID",

"PROD_ID",

"PROMO_ID",

"QUANTITY_SOLD",

"TIME_ID"

FROM

SH.SALES;

The error after the reload is given is this:

ODBC read failed
SQL Select
"AMOUNT_SOLD",
"CHANNEL_ID",
"CUST_ID",
"PROD_ID",
"PROMO_ID",
"QUANTITY_SOLD",
"TIME_ID"

FROM SH.SALES