4 Replies Latest reply: Jul 24, 2017 4:08 PM by Saima SM RSS

    Using Pick or Match in chart functions- Qlik Sense

    Saima SM

      Hi All,

       

      I have been using nested if statements in my chart functions. Can any body pleases help me any optimized way e.g. if I want to convert it using pick/match how the script would be transformed then. Thanks

       

      E.g. Given the script

       

      if(ValueList('Additional Testing,'Advice on  Pathways', 'Advice Provided', 'Advice Provided Description',
      'Medication Recommendation', 'More Info Needed' )  = 'Additional Testing', count([Additional Testing])/
      count(total [Additional Testing]),

       

      if(ValueList('Additional Testing,'Advice on  Pathways', 'Advice Provided', 'Advice Provided Description',

      'Medication Recommendation', 'More Info Needed' ) = 'Advice on Pathways',
      count([Advice on Pathways])/count(total [ Advice on Pathways])

      AND SO ON....

       

      Please Help. Thanks