topic Re: RE;Replace...? in QlikView

RE;Replace...?

Chanty4u — Wed, 06 Jan 2016 13:39:06 GMT

hi all,

i have data lik complxcity values 2,4,8.

filedname :cmplexity

and i want to replce 2 as simple, 4 as expect, 8 as common

how can i achive in script?

thnks in advance...

Re: RE;Replace...?

sunny_talwar — Wed, 06 Jan 2016 13:42:35 GMT

May be this:

Pick(Match(cmplexity, 2, 4, 8), 'simple', 'expect', 'common')

Re: RE;Replace...?

Anonymous — Wed, 06 Jan 2016 13:44:28 GMT

like this?

if(Complexity=2, 'Simple',

if(Complexity=4, 'Expect',

if(Complexity=8, 'Common'))) as NewField

Re: RE;Replace...?

Kushal_Chawda — Wed, 06 Jan 2016 13:49:13 GMT

=Pick(Match(cmplexity,'2', '4','8'), 'simple', 'expect', 'common') as Complexity_new

Re: RE;Replace...?

HirisH_V7 — Wed, 06 Jan 2016 13:55:33 GMT

Hi ,

Like this,

T:
REPLACE ONLY LOAD * INLINE [
    Type, Value
    Simple, 2
    Expect, 4
    Common, 8
   ];
T:
LOAD * INLINE [
    Type
    Simple
    Expect
    Common and Other
];

It Helps for large data sets,

Hope this Helps,

Hirish

Re: RE;Replace...?

sunny_talwar — Wed, 06 Jan 2016 13:55:48 GMT

On similar lines:

=Dual(Pick(Match(cmplexity, 2, 4, 8), 'simple', 'expect', 'common'), cmplexity) as cmplexity

This avoid having two fields telling the same story

Re: RE;Replace...?

Chanty4u — Wed, 06 Jan 2016 14:07:19 GMT

thnx all...all r wrkng fyn...i used If cndition

Re: RE;Replace...?

Chanty4u — Wed, 06 Jan 2016 14:11:23 GMT

nice hirish