topic Re: If... else... in QlikView

If... else...

Wed, 25 Nov 2020 16:16:04 GMT

I'm trying to write a if else function in script to modify some strings, for example:

Original strings:

Index

Chris

Doug

Target output:

Name

Alex

Brad

Chris

Doug

My script:

If(Index = 'A', 'Alex', If(Index = 'B', 'Brad', XXX)) as Name

What should I put into XXX if I don't want to list what I already have in [Index]('Chris' & 'Doug' in this case) and keep them as they are in [Index]?

Re: If... else...

oscar_ortiz — Thu, 15 Jun 2017 17:44:01 GMT

Check out what I've done here using a mapping load and the ApplyMap function.

Good luck!

Oscar

Re: If... else...

oscar_ortiz — Thu, 15 Jun 2017 17:47:28 GMT

A quick note on the ApplyMap function.

You can pass two required parameters or a third optional parameter.

The two required parameters are the Map Name (1st) the Lookup value (2nd) and finally the optional parameter of a default value returned if not found. In the two parameter version the 2nd parameter will be used as the default value.

Thanks again

Oscar

Re: If... else...

dan_sullivan — Thu, 15 Jun 2017 17:58:30 GMT

If(Index = 'A', 'Alex', If(Index = 'B', 'Brad', Index)) as Name

Re: If... else...

oscar_ortiz — Thu, 15 Jun 2017 18:05:58 GMT

A reason to consider using the ApplyMap function instead of the IF statement is when you have more than a handful of checks that you need to do. That IF statement is going to get huge when you have ten or more values to check.

Just my two cents...

Re: If... else...

Thu, 15 Jun 2017 18:10:25 GMT

Thank you Oscar, that's pretty useful advice. Right now I only have a small list, but ApplyMap is definitely useful when the list is huge.