topic nested select/query in QlikView

nested select/query

Tue, 21 Jul 2009 20:23:28 GMT

Hi!

Can I use nested select in Qlikview? I have tried to include the following select statement in the script but haven't succeeded. can somebody advise me with this?

SELECT
AMOUNTMST
FROM (SELECT
DELIVERYDATE,
(REMAINPURCHPHYSICAL + REMAINPURCHFINANCIAL) *

PURCHPRICE * (SELECT TOP ( 1 ) EXCHRATE
FROM DBO. EXCHRATES
WHERE (CURRENCYCODE = P. CURRENCYCODE)) AS AMOUNTMST

FROM DBO. PURCHLINE AS P)

Thanks,

Petteri

nested select/query

Tue, 21 Jul 2009 20:47:13 GMT

Yes you can, try to run same query in SQL (SQLSERVER) first, if that runs properly, there should not be an issue.

nested select/query

amars — Tue, 21 Jul 2009 21:06:01 GMT

After From you have forget to put the Table name. Try to run query in sql server first.