how to use preloaded data.

[#1]

hello,

i want to use the data of a field which is preloaded by following query:

products:

SELECT "SYSCDS_CODE_DESC" PRODUCT_CATEGORY,"ITEM_ITEM_NAME" , "ITEM_ITEM_CODE"
FROM "NEWTON_BI1"."STR_ITEM_M" a, "NEWTON_TRADE"."COR_SYSCODES" b ,"NEWTON_BI1"."MKG_SALE_D" c
WHERE "SYSCDS_CODE_TYPE"= 'PRODUCT_CODE' AND
substr("SALE_ITEM_CODE",2,2)=b."SYSCDS_CODE_VALUE"
AND c."SALE_ITEM_CODE" = a."ITEM_ITEM_CODE";

i want use "ITEM_ITEM_CODE" field in other query but its giving error as "table not found"

plz suggest answer.

[Anonymous]

Did you consider combining the tables? Loading the data from the tables in seperate LOAD statements and then join them together.

Qlikview works slightly different from normal database stuff ... what normally would look like good SQL in Qlikview works differently.
Sometimes you should throw your database knowledge overboard to work with QlikView logic of databases 😉

[#3]

thanks !!

i agree with ur suggestion. is ur suggestion the only way to perform this?

i just want to know that is there any function or way to reuse

the sorted data contained in item_item_code field which i m taking from mentioned query.