topic Re: Scenario Help in QlikView

Scenario Help

abhaysingh — Wed, 29 Apr 2015 06:21:13 GMT

Hi all,

i have two tables, table1 and table2..

in table1 i have customer key and table2 i have one more customer key field.

i want to compare where table1 customer1 in not equal to table 2 customer key and have to show sales.

how i can write expression at front end or backend.

thanks

Re: Scenario Help

Wed, 29 Apr 2015 06:25:43 GMT

hi,

join both table or concatenate .

i am giving some idea regarding Concatenate

MAIN:

LOAD *, Cust as key1

from table1;

concatenate

LOAD *,Cust as key2

from table 2;

MAIN2:

LOAD *,

if(key1<>key2,customersale) as flag

resident MAIN;

drop table MAIN;

Regards

Vimlesh

Re: Scenario Help

PrashantSangle — Wed, 29 Apr 2015 06:34:06 GMT

Hi,

In script ,

You can acheive it using not exist()

try like

MAIN:

LOAD *, Cust as key1

from table1;

table2:

LOAD *,Cust as key2

from table 2

where not exist(key1,Cust);

Regards

Re: Scenario Help

abhaysingh — Wed, 29 Apr 2015 06:34:15 GMT

hi vimlesh,

not possible to concatinate or join table1 and table2. result set has been impacted

Re: Scenario Help

Wed, 29 Apr 2015 06:36:19 GMT

hi,

if you want to use in script then both table should be in one table.

else you can do in front end.

Check by which your result data is impacted by concatenate or join (drop field by field and check).

Regards

Vimlesh

Re: Scenario Help

anbu1984 — Wed, 29 Apr 2015 07:10:48 GMT

Do you want to show sales of customers present in one table and not in other? Try like this

Table1:

Load * From Table1;

Table2:

NoConcatenate

Load *,If(Exists(CustKeyField),0,1) As Flag From Table2;

In UI,

Expr: Sum({<Flag={1}>} Sales)