topic Re: Custom sql join in QlikView

Custom sql join

manoj217 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Custom sql join

wdchristensen — Tue, 20 Mar 2018 17:31:22 GMT

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

where A.sales > 1,000 AND NOT B.cost < 10,000

Re: Custom sql join

Siva_Sankar — Mon, 26 Mar 2018 01:49:18 GMT

Manoj,

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.

-Siva