topic SQL Statement in QlikView in QlikView

SQL Statement in QlikView

Wed, 29 Jul 2015 08:32:08 GMT

Hey,

how can i build the attached file in QlikView?

Thank you

MK_QSL — Wed, 29 Jul 2015 08:36:11 GMT

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

Otherwise use as below

Load * From Table1:

Left join (A)

Load * From Table2:

johanlindell — Wed, 29 Jul 2015 08:36:43 GMT

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

sushil353 — Wed, 29 Jul 2015 08:37:47 GMT

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;

tresB — Wed, 29 Jul 2015 08:38:43 GMT

Try like:

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