Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld Online 2021, May 10-12: Our Free, Virtual, Global Event REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
guruprem
Partner
Partner

Alternative to IF statement

Dear Experts,

I am bored of writing IF statement to replace data with dummy data, please suggest me the quickest way, following is example of what I wanna achieve.

CurrentFeild  ResultFeild

James     Apple

John        Banana

Sarah      Avpcado

...               ....

1 Solution

Accepted Solutions
jonathandienst

Create a mapping table (load from inline or from Excel) and use ApplyMap to replace the current field with the result.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

3 Replies
jonathandienst

Create a mapping table (load from inline or from Excel) and use ApplyMap to replace the current field with the result.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

colin_albert

Applymap is the better option.

See this post for more details Don't join - use Applymap instead

reddy-s
Master II
Master II

Hi Guruprem,

You can also make use of a Lookup() function.

Thanks,

Sangram.