2 Replies Latest reply: May 7, 2018 9:02 PM by Joe Easley RSS

    Is there a better way to write this in Qlik script

    Ramya Sai

      Hello Community,

      I have  written a nested if function to achieve this but was wondering is a there a better way to write the same in qlik script using qlik functions? please give me your inputs.

      if( Name='AK', 'Yes' ,

      if( Name='KK', 'Yes' ,

      if( Name='MK', 'Yes' ,

      if( Name='TK', 'Yes' ,

      if( Name='HK', 'Yes' ,

      if( Name='BK', 'Yes' , 'No'))))) as Main

       

       

      Thanks,

      Ramya