topic Re: Matching Values in QlikView

Matching Values

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

Hi friends,

I have a below table in that some of the columns emp_id is blank. so my req is if sales id is present and emp id is blank in that case need to display new column as status yes else No.

sales_id	sales_name	sales	emp_id	emp_name
1	aaa	10		zz
2	bbb	20		xx
3	ccc	30	123	yy
4	ddd	40	456	tt
5	eee	50	789	vv

Thanks,

Re: Matching Values

tamilarasu — Wed, 05 Oct 2016 07:50:29 GMT

Hi Kumar,

Load *,

If(Len(Trim(emp_id))=0, 'Yes','No') as Status;

LOAD * INLINE [

sales_id, sales_name, sales, emp_id, emp_name

1, aaa, 10, , zz

2, bbb, 20, , xx

3, ccc, 30, 123, yy

4, ddd, 40, 456, tt

5, eee, 50, 789, vv

];

Re: Matching Values

vinod2086 — Wed, 05 Oct 2016 07:58:07 GMT

Thanks for reply nag,

i got solution simply i applied if condition

if(IsNull(EMP_ID) and not IsNull(SLS_TTY_ID),'y','n')as new

this condition is working.

Re: Matching Values

Anil_Babu_Samineni — Wed, 05 Oct 2016 08:00:18 GMT

You can try this too

If(emp_id= '', 'Yes','No') as Status

If(Trim(emp_id)= '', 'Yes','No') as Status

Re: Matching Values

tamilarasu — Wed, 05 Oct 2016 08:12:45 GMT

I assume that sales_id field cannot be null and thus suggested the above solution. Anyways, you go the solution. Have a nice day.