8 Replies Latest reply: Apr 14, 2017 8:05 AM by Robin Hausdörfer RSS

    Expression for dynamic values in qlik

    Supriya R

      Hi,

       

      i have a table like below

       

      Table1:

      Load * Inline [

      Country, rank

      Malasia,1

      Goa,5

      Germany,6

      Korea,4 ];

       

       

      i need a expression where it compares rank of country, i.e if rank of Country = 1, "I am in Malaysia", if rank of Country = 5, "I am in Goa"....

       

      What should be my express here?