How prefix value of applymap with some value

[qlikviewforum]

Imagine I have following value for the field called "Product".

Product
-------
Pen
Pencil
Eraser
Box

Account
------
XXX
YYY
ZZZ
PPP

I want use ApplyMap, if the value of product is Pencil then while using ApplyMap I need to Prefix the corresponding Account with AA.

For example if the Account value of Pencil is zzz then I want to prefix it with AA. So the value of ApplyMap field will be AAXXX.

Please help me on this...

[qlikviewforum]

Thanks all guys. I will check all your suggestions and will keep you updated on that.

[#3]

if(product='Pencil','AA')&applymap(.....)

[qlikviewforum]

Thank you!

What about he else part when the Product <> "Pencil" ?  or was I'm missing something in your logic?

[#5]

it will just ignore tht or ur can use if(product='Pencil','AA','')&applymap(.....)

[qlikviewforum]

Then later we can trim it to avoid any issue. Am I correct?

trim(if(product='Pencil','AA','')&applymap(.....))