topic Re: IF CONDITION in QlikView

IF CONDITION

Sat, 19 Jul 2014 11:22:12 GMT

Hi I have condition as below

(If Tag1<>’ ’, Tag1,Tag) as MapKey

The Above Condition would make data flow as below

Still This Condition everything works fine but my database have even has value

As Below:

Where all the MapKey are Replaced By TAG1 as per the Condition

(If Tag1<>’ ’, Tag1,Tag) as MapKey

Kindly suggest me condition to derive the below result

Thanks In Advance

Vinayagam

MK_QSL — Sat, 19 Jul 2014 11:52:00 GMT

IF(TAG1='' and TAG='','A',IF(TAG1 <>'',TAG1,TAG)) as MapKey

Sat, 19 Jul 2014 12:09:38 GMT

Thank you Sir

But i dont have any Tag1 or Tag has blank , i want to derive the result as the last table srno 6

MK_QSL — Sat, 19 Jul 2014 13:21:33 GMT

IF(TAG1='' and TAG='','A',IF(TAG1 <>'',TAG1,TAG)) as MapKey

Is not giving u desired result? What I am missing? Please explain