nested select/query

[#1]

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

[#2]

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

[amars]

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