Qlikview Script - If a Value then replace with new Value

[MacChick]

I want to either script of create an expession to look up an old value and if it matches, replace with new value.

Something like the following:

If(WildMatch(Model = 'Rugged*', 'Latitude 5430 Rugged'),
If(WildMatch(Model = 'Latitude 7*', 'Latitude 5450'),
If(WildMatch(Model = 'Optiplex*', 'Optiplex (7020) SFF'))))as NewMachine,

If the old value contains Rugged, then give me the new value of Latitude 5430 Rugged

What do you recommend to accomplish this, I am using Qlikview Desktop Personal.

I am working on a dataset of 4000 machines and am trying to work out what I need to purchase based on current machine type.

[marksouzacosta · Accepted solution]

Hi @MacChick ,

You are almost there. Try this:

If(WildMatch(Model,'*Rugged*'), 'Latitude 5430 Rugged',
If(WildMatch(Model,'Latitude 7*'), 'Latitude 5450',
If(WildMatch(Model,'Optiplex*'), 'Optiplex (7020) SFF')
)) as NewMachine,

Regarding your machine, QlikView mostly depends on memory RAM since everything is processed in the RAM. Nice processor and fast hard drive disks are also always a good idea to have. 

Regards,

Mark Costa

[MacChick]

Thanks so much! It's been a while since I have scripted in Qlikview.