topic Regarding applymap function in QlikSense in App Development

Regarding applymap function in QlikSense

skiruthigadevi — Mon, 07 Dec 2020 16:43:48 GMT

Hello Folks,

Appreciate your time.

I am trying to do an applymap in a portion of my field.

for eg, I have a field called Report_Vendor_Prodid which has value 7|ABC|123 ,

I would like to swap the prodid with product category. let say the above prodid belongs to product category 1 then my result would like some thing below

7|ABC|1

could you kindly let me know your feedback.,thank you!

Kiruthiga

Re: Regarding applymap function in QlikSense

Gui_Approbato — Mon, 07 Dec 2020 22:24:56 GMT

Hello,

You need to load the mapping table prior to the data table, with the "mapping" argument.

Then, in your data table you use the Applymap with the name of your mapping table.

It would be something like this:

Mymap:

Mapping Load * Inline [

From , To

123 , 1

x , y ] (delimiter is ',') ;

Data:

Load Column1,Column2, Applymap('MyMap', Prodid) as Category , ... from..;

Your mapping table must contain only 2 columns.