topic Re: sql sub-query in Qlikview in QlikView

sql sub-query in Qlikview

arumugam_siva — Sat, 16 Nov 2024 04:12:56 GMT

Hi All,
I am new to Qlikview.I am given SQl code based on that,I need to write one expression in qlikv text object.I have two tables (concentated) A&B.I need to show the sum of the amount in table A where (some condition)+sum of amount in table where(column in table B = table A).I have used sum with set expression but don't know how to write (column in table B = table A).Any idea/suggestion?

Re: sql sub-query in Qlikview

dplr-rn — Mon, 11 Mar 2019 16:59:34 GMT

Use something like below

= {$<PK= {"=ColumnA= ColumnB"}>}

or if the 2 tables are 1-1 join the tables into a single one and you can create a flag in the script:

If(ColumnA= ColumnB, 1, 0) as Flag

and then this

= {$<Flag = {1}>}