4 Replies Latest reply: Feb 23, 2012 4:01 PM by Ralf Becher RSS

    escape character in parameter for set analysis

      Hi!

       

      In a previous question I asked about parameters in set analysis (http://community.qlik.com/message/194157#194157) now while working with it I could use an escape character...

       

      When supplying two arguments in a set analysis we wright Year={2010,2011}. How to accomplish that with argument?

      Now I'm using sum of the two but I'd like to be able to supply it in the argument.

       

       

      =$(vQ_MC_KI_ant('Bruttoköp','EEA'))+$(vQ_MC_KI_ant('Bruttoköp','EMU'))
      
      This don't work:
      =$(vQ_MC_KI_ant('Bruttoköp','EEA,EMU'))
      

       

      How to escape the comma in 'EEA,EMU'?

       

      regards

      thomas