topic how to replace values in a dimension in QlikView

how to replace values in a dimension

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

i m using if("SBU Head Name"='-' and CBU='-','others') as "SBU Head Name" condition in load editor, but it is giving me error as sbu head name already exists. I want my sbu head name's satisfying the condition to be relpaced by others

Re: how to replace values in a dimension

jonathandienst — Wed, 26 Jul 2017 13:16:35 GMT

Either
Change the name of the derived field so it does not conflict with the existing field

Remove the other [SBU Head Name] from the load statement or alias as something else, like

[SBU Head Name] as [Orig SBU Head Name],

If the load statement uses a LOAD * structure, you will need to expand the * to explicitly control the actual field names returned by the LOAD

Re: how to replace values in a dimension

arvind_patil — Wed, 26 Jul 2017 13:25:42 GMT

Hi Sidhharth,

Please try below Code:

IF(Isnull([SBU Head Name]) and isnull(CBU)),'Others') as [New Field];

Thanks,

Arvind Patil