4 Replies Latest reply: Dec 18, 2017 1:28 AM by Aki Martiskainen RSS

    If statement in a String

    Aki Martiskainen

      Hello

       

      First time posting and I hope it's in the correct section. Please feel free to move if necessary.

       

      I'm completing the exercises in the Qlik continuous classroom and I came across a step in a certain exercise that I don't understand.

       

      Learning module: Business Analyst > Create Visualizations > Introduction to String Functions

       

      One step in this exercise is to use the following string in a new dimension in order to organize data by region in a Filter Pane.

      If(Right(Region,7)='America','Americas','EMEA')

       

      In the Filter Pane there is a dimension "Region" which contains the following values: "Europe", "North America" or "South America"

       

      While the string is working great and returns values North America -> Americas, South America -> Americas, Europe -> EMEA in the new dimension, I'm frustrated because I can't understand how it actually works. I tried looking for similar problems with If statement combined with string function Right but no luck.