SQL Statement in QlikView

[#1]

Hey,

how can i build the attached file in QlikView?

Thank you

[MK_QSL]

If you are fetching data directly from Database, you can use the same SQL statement in QlikView script.

Otherwise use as below

A:

Load * From Table1:

Left join (A)

Load * From Table2:

[johanlindell]

You should be able to implement a Venn-diagram from google charts into your application.

See Venn Diagram in Qlikview using google chart api

[sushil353]

Hi,

You can simply write your sql script using SQL keyword as

Table:

Load *;

SQL Select <list>

From TableA A

Left join TableB B

ON A.Key = B.Key

where B.Key is NULL;

[tresesco]

Try like:

Load Key,
      field1,
      field2
From TableAA
Left Join
Load Key
      filed3
      field4
From TableBB where Isnull(Key);