topic Re: Update the field in QlikView

Update the field

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

Hi experts,

I am having one table with 6 fields including applymap.

So now my question is want to update the applymap field with conditions.

Can you please help me on the same..

Thanks in advance...

Re: Update the field

YoussefBelloum — Wed, 21 Feb 2018 14:00:50 GMT

Hi,

what is the condition you want to apply with the applymap ?

Please try to explain in detail what you want to do

Re: Update the field

clondono — Wed, 21 Feb 2018 14:07:34 GMT

Can you share a sample of your data?

Maybe something like this will work for you:

// Load mapping table of your fields:

map1:

mapping LOAD *

Inline [

Field1, Field2

Xx, YYYY //X and Y is your data

Xxx, Yyyy

] ;

map2:

mapping LOAD *

Inline [

Field1, Field2

Xx, YYYY //X and Y is your data

Xxx, Yyyy

] ;

// Load list dimensions

YourTableName:

LOAD *,

If(Your first condition here,

ApplyMap('map1', Xx,'What to replace with'),

Your second condition here,

(ApplyMap('map2', Xx,'What to replace with'))) As YourFieldName ;

Re: Update the field

Anonymous — Wed, 21 Feb 2018 14:07:38 GMT

Thanks for the reply

Let us assume that i have one applymap field called name

now i need to update the name field to apple

now my condition is if (name ='mango' and product ='hai' ) THEN 'mangonew' else name

Can you please tell me niow?

Re: Update the field

YoussefBelloum — Wed, 21 Feb 2018 14:24:21 GMT

as soon as you want to put a condition on the field name, you will have different fields (with different names), here you will have 2 different field (appe, mangonew)

Try this:

if(match(name,'mango') and match(product,'hai'), ApplyMap('mapping_table_name', ...,'...')) As apple,

if(not match(name,'mango') and not match(product,'hai'), ApplyMap('mapping_table_name', ...,'...')) As mangonew