topic Re: Change value in the field in QlikView

Change value in the field

AH — Tue, 20 Jan 2015 19:29:21 GMT

Hi,

I would like to force some value in a field to change into something else. This is what i am writing in my script,

if(DataAreaId='tgbr' or DataAreaId ='TGNL','tgnl') as DataAreaId

I want to make the value "tgbr" and "TGNL" to "tgnl". What i am doing wrong in my script?

Thanks,

Shan

Anonymous — Tue, 20 Jan 2015 19:36:24 GMT

I guess you want this:

if(DataAreaId='tgbr' or DataAreaId ='TGNL','tgnl', DataAreaId) as DataAreaId

AH — Tue, 20 Jan 2015 19:45:46 GMT

Hi Michael,

Thanks for your reply. TGNL changed to tgnl but tgbr didnt changed to tgnl.

Thanks,

Shan

maxgro — Tue, 20 Jan 2015 19:51:54 GMT

if(match(lower(DataAreaId), 'tgbr', 'tgnl'), 'tgnl', DataAreaId) as DataAreaId

Anonymous — Tue, 20 Jan 2015 19:53:53 GMT

Try this:
if(wildmatch(DataAreaId,'*tgbr*','*TGNL*'), 'tgnl', DataAreaId) as DataAreaId

AH — Tue, 20 Jan 2015 20:04:25 GMT

Massimo,

I got it fixed. Thank you so much.

Shan

AH — Tue, 20 Jan 2015 20:15:10 GMT

Massimo,

Oops! Sorry, in the textbox its showing the tgbr is gone. But while i looked at the table i see the tgbr is replaced by ' - ' hyphen.

Thanks,

Shan

Anonymous — Tue, 20 Jan 2015 21:08:42 GMT

Have you tried the "wildmatch" expression? If it doesn't help, there is something in the data we can't guess, and need an example of your file...

AH — Tue, 20 Jan 2015 21:12:13 GMT

Michael,

I am really sorry not to mention it before. I tried with the wildmatch but it didnt work either.

I dont know if anything wrong with the data. I have to check again and i will get back again later.

Thanks for all your replies.

Thanks,

Shan