topic Re: Qlikview Script - If a Value then replace with new Value in QlikView

Qlikview Script - If a Value then replace with new Value

MacChick — Fri, 31 Jan 2025 20:34:28 GMT

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.

Re: Qlikview Script - If a Value then replace with new Value

marksouzacosta — Fri, 31 Jan 2025 21:04:09 GMT

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

Re: Qlikview Script - If a Value then replace with new Value

MacChick — Fri, 31 Jan 2025 21:22:44 GMT

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