topic Re: How prefix value of applymap with some value in QlikView

How prefix value of applymap with some value

qlikviewforum — Thu, 20 Mar 2014 17:19:12 GMT

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...

Re: How prefix value of applymap with some value

Thu, 20 Mar 2014 17:22:31 GMT

use another applymap function to get the prefix (AA) and concatenate both apply maps

ex: applymap('Prefix',product,'NA') &applymap('mapacct',product,'NA')

Re: How prefix value of applymap with some value

MK_QSL — Thu, 20 Mar 2014 17:30:34 GMT

Can you provide AccountValue and Prefix for all the above products

Re: How prefix value of applymap with some value

qlikviewforum — Thu, 20 Mar 2014 18:04:35 GMT

We need to prefix AA whatever account value is there. Please let me know if it is not understandable.

GGG --> AAGGGG

JJJ --> AAJJJ

Re: How prefix value of applymap with some value

Thu, 20 Mar 2014 18:06:08 GMT

if the prefix is not based on your product, just use 'AA'&applymap(.....) as fieldname.

Re: How prefix value of applymap with some value

qlikviewforum — Fri, 21 Mar 2014 02:23:20 GMT

Thank you

But it should be only when the Produuct=Pencil and it is not for all. Hope it is clear now!

Re: How prefix value of applymap with some value

qlikviewforum — Fri, 21 Mar 2014 05:04:53 GMT

Hi Manish,

Above is just the sample data to understand my requirement. I am little stuck with the logic and to implement this.

Re: How prefix value of applymap with some value

CELAMBARASAN — Fri, 21 Mar 2014 05:09:19 GMT

Use

Account & Applymap('ApplymapTable', Product)

Re: How prefix value of applymap with some value

rwunderlich — Fri, 21 Mar 2014 05:13:44 GMT

=if(Product='pencil','AA','') & applymap('MyMap', Product)

-Rob

Re: How prefix value of applymap with some value

Fri, 21 Mar 2014 05:16:04 GMT

Hi,

Try this script

Map:
Mapping Load * Inline [
Product, Prefix
Pen, AA
Pencil, BB
Eraser, CC
Box, DD
];

Test:
Load * Inline [
Product, Account
Pen, XXX
Pencil, YYY
Eraser, ZZZ
Box, PPP
];

Result:
Load *,
ApplyMap('Map',Product)&Account as Result
Resident Test;

Drop Table Test;

Re: How prefix value of applymap with some value

qlikviewforum — Fri, 21 Mar 2014 05:21:15 GMT

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

Re: How prefix value of applymap with some value

Fri, 21 Mar 2014 11:09:46 GMT

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

Re: How prefix value of applymap with some value

qlikviewforum — Fri, 21 Mar 2014 11:18:14 GMT

Thank you!

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

Re: How prefix value of applymap with some value

Fri, 21 Mar 2014 11:21:13 GMT

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

Re: How prefix value of applymap with some value

qlikviewforum — Fri, 21 Mar 2014 11:48:52 GMT

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

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