topic Re: Formula on a field in QlikView

Formula on a field

qlikviewaf — Mon, 04 Dec 2017 11:14:08 GMT

Hi,

i would like to use this formula on my script, but i got an error saying "the field name should be unique".

How i can manage this in a afficient way?

Thanks

if(Match(trim(

),'ACT'),'Adjustment', Country_Desc) as Country_Desc

prma7799 — Mon, 04 Dec 2017 11:15:06 GMT

Try this

if(Match(trim(

),'ACT'),'Adjustment', Country_Desc) as Country_Desc_New

qlikviewaf — Mon, 04 Dec 2017 11:16:06 GMT

I would like to mantain the same Field Name since all my app has been build using Country_desc

prma7799 — Mon, 04 Dec 2017 11:18:59 GMT

You don't allow same name in one table ...

Either you can rename your old filed or new field like this

1....

Load

Country_Desc as Country_Desc_Old,

if(Match(trim([Code]),'ACT'),'Adjustment', Country_Desc) as Country_Desc

...

From ....

2...

Load

Country_Desc ,

if(Match(trim(

),'ACT'),'Adjustment', Country_Desc) as Country_Desc_New

...

From ....

stabben23 — Mon, 04 Dec 2017 11:19:04 GMT

Then you have to rename the Original Field, like Country_Desc as Country_Desc_Org. Or comment the Field away from script using //Country_Desc

Anil_Babu_Samineni — Mon, 04 Dec 2017 11:28:14 GMT

Perhaps this

Pick(Match(trim(

),'ACT')+1,'Adjustment', Country_Desc) as Country_Desc