topic how to use preloaded data. in QlikView

how to use preloaded data.

Thu, 03 Dec 2009 18:02:22 GMT

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.

how to use preloaded data.

Anonymous — Thu, 03 Dec 2009 20:40:11 GMT

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 😉

how to use preloaded data.

Fri, 04 Dec 2009 11:51:43 GMT

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.