is it possible custom sql join in qlikview with multiple AND OR conditions can you please tell me with an example, I don't want the load statement in that
You can load any valid SQL, so you can customize the join (inner, outer, left, right) however you want and then load that into Qlik. If that is not what you mean by "custom join" can you provide an example?
SQL
Select *
From A left outer join B on A.ID = B.ID and A.Type = B.Type OR A.GUI = B.GUI
Custom SQL is not available in Qlikview unlike other tools(Tableau). So you can use the same SQL which you write for the databases. Whereas in other tool you dont have (Tableau) cant write same sql which you write in database.
