Discussion Board for collaboration related to QlikView App Development.
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
Missing Manual - Map...using
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.
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 .
look in that way.
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)