topic Add values from another column to required column in QlikView

Add values from another column to required column

Anonymous — Thu, 07 Apr 2016 11:51:40 GMT

Hi All,

My requirement is replace Financial Advisory to FA –DA and FA –JV

Financial Advisory from Function .

FA –DA and FA –JV from Function – Others

‘Function’ is old column ‘Function – Others’ is newly added colum

old :

Function
Audit & Assurance
Consulting
ERS
Financial Advisory
Internal Firm Services
Tax

Required:

Function
Audit & Assurance
Consulting
ERS
FA –JV
FA –DA
Internal Firm Services
Tax

Thanks,

Krishna

Re: Add values from another column to required column

Chanty4u — Thu, 07 Apr 2016 11:54:16 GMT

Missing Manual - Map...using

Re: Add values from another column to required column

HirisH_V7 — Thu, 07 Apr 2016 12:04:48 GMT

Hi,

On what basis does these replace Financial Advisory to be replaced to FA –DA and FA –JV if it is based on the Emp id means we have to write condition for each and every emp id.

Can you provide more info if available.

-Hirish

Re: Add values from another column to required column

Anonymous — Thu, 07 Apr 2016 12:10:58 GMT

Hi Harish,

From March Financial Advisory divided in to FA –DA and FA –JV .

I need to remove Financial Advisory from Function first. next add FA –DA and FA –JV .

Thanks,

Krishna

Re: Add values from another column to required column

HirisH_V7 — Thu, 07 Apr 2016 12:17:58 GMT

On what basis it got divided into FA –DA and FA –JV From March .

Is there any particular case for DA and JV in your logic or any other column which tells the correspondence to it.

look in that way.

-Hirish

Re: Add values from another column to required column

sunny_talwar — Thu, 07 Apr 2016 12:19:20 GMT

How can you add two different options for one value? Is there another if here?

If(Function = 'Financial Advisory',

If(FieldName = BlahBlah, 'FA-DA',

If(FieldName = BlahBlah2, 'FA-JV')), Function)