Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
krishna4bo
Contributor

Add values from another column to required column

  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 columnFunction – 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

 

5 Replies
Highlighted
Chanty4u
Esteemed Contributor III

Re: Add values from another column to required column

Highlighted
HirisH_V7
Honored Contributor

Re: Add values from another column to required column

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

HirisH
“Aspire to Inspire before we Expire!”
Highlighted
krishna4bo
Contributor

Re: Add values from another column to required column

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

Highlighted
HirisH_V7
Honored Contributor

Re: Add values from another column to required column

  • 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

HirisH
“Aspire to Inspire before we Expire!”
Highlighted

Re: Add values from another column to required column

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)