if statement with not exists

Thu, 29 Jan 2015 14:38:19 GMT

hi guys,

I have following problems:

T1	Seller
1	A
2
3	C

T2	Seller
qw	A
as	B
yx

T1	T2
1	qw
2	as
3	yx

I want to show all the Seller: 1,2,3 WITHIN to fill the missing information like:

a) if I click B, it only shows "as", not "2" from T1

so how can I tell Qlik in Script, that:

If no seller in T1, look in T2 ?

and reversed ..

Like:

If T1 has not Seller, so look in T2 and summit that 2=as=B -> 2=B

If(Seller not exists in T1,

I am sorry for my english

Re: if statement with not exists

rubenmarin — Thu, 29 Jan 2015 15:10:52 GMT

Hi Thomas, maybe helps if you can assing in script T1 and T2 for each seller, this way will be easier to get the associated value, you can do this:

// ***** Original data *****

T1:

LOAD * Inline [

T1,Seller

1,A

3,C

];

T2:

LOAD * Inline [

T2,Seller

qw,A

as,B

];

Relations:

LOAD * Inline [

T1,T2

1,qw

2,as

3,yx

];

// ***** Creating Mapping *****

Map_T1:

Mapping LOAD T1,Seller Resident T1;

Map_T2:

Mapping LOAD T2,Seller Resident T2;

MAP_RelationsT1_T2:

Mapping LOAD T1, T2 Resident Relations;

MAP_RelationsT2_T1:

Mapping LOAD T2, T1 Resident Relations;

// ***** Create table by seller with T1 and T2 *****

Result_tmp:

NoConcatenate LOAD T1,

If(IsNull(Seller) or Seller='', ApplyMap('Map_T2', ApplyMap('MAP_RelationsT1_T2', T1)), Seller) as Seller

Resident T1;

Concatenate LOAD T2,

If(IsNull(Seller) or Seller='', ApplyMap('Map_T1', ApplyMap('MAP_RelationsT2_T1', T2)), Seller) as Seller

Resident T2;

Result:

NoConcatenate LOAD Seller, MinString(T1) as T1, MinString(T2) as T2 Resident Result_tmp Group By Seller;

DROP Tables T1, T2, Relations, Result_tmp;

topic if statement with not exists in QlikView

if statement with not exists

Re: if statement with not exists