Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
ankitasinghal
New Contributor II

help in converting SQL OR condition in QV script joins

Hi Geeks,

I have below requirement

suppose we have 4 tables A, B,C,D

and I have below SQL query i want convert this query in QV kindly help me in this.

in below SQL query i am not able to write QV logic for ((A.col2=D.col2) or (B.col2 is null))  or condition.

SQL query.

select *

from table A left join table B

on  A.col1=B.col2

left join C

on A.col1=C.col1

left join D

on

A.col1 =D.col1

and ((A.col2=D.col2) or (B.col2 is null))

Thanks,

Ankita Singhal

stalwar1

Tags (1)
2 Replies
tripatirao
Contributor II

Re: help in converting SQL OR condition in QV script joins

Hi,

Try to make 4 tables in excel by taking some sample data.

Load these table into qlikview and try to join

chinnuchinni
Contributor III

Re: help in converting SQL OR condition in QV script joins

you can easily achieve this with the preceding load.

just give the same name to the fields  to join the tables.

if you need proper solution please attach the sample data and your required o/p.