Changing one specific field in table

Wed, 25 Nov 2020 16:16:04 GMT

Hi all,

I am rather new in qlikview development so I have one question for you.

I have a table of partners and each of the partners (PAR_ID) is connected with currency via CUR_ID. During my analysis I realized that for some partners I have incorrect currencies in DB and I would like to change that in Qlikview Model directly. What I wanted is to apply the following function:

if(PAR_ID=39, VAL_ID=4, VAL_ID)

explanation: if PAR_ID=39 set VAL_ID to be 4, otherwise keep original VAL_ID

Since this is the fist time I'm doing this, normally it did not give expected results.

Can you please advise me how to implement this.

Regards

Vera

Re: Changing one specific field in table

sunny_talwar — Thu, 18 Aug 2016 09:46:26 GMT

Try this:

If(PAR_ID=39, 4, VAL_ID)

Re: Changing one specific field in table

Kushal_Chawda — Thu, 18 Aug 2016 09:47:20 GMT

try this

LOAD *,

if(PAR_ID=39, 4, VAL_ID) as VAL_ID

FROM table

topic Re: Changing one specific field in table in QlikView

Changing one specific field in table

Re: Changing one specific field in table

Re: Changing one specific field in table