Discussion board where members can get started with QlikView.
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.
from table A left join table B
left join C
left join D
and ((A.col2=D.col2) or (B.col2 is null))
Try to make 4 tables in excel by taking some sample data.
Load these table into qlikview and try to join
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.