escape character in parameter for set analysis

[#1]

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

[CELAMBARASAN]

Hi,

     Try this.

     =$(vQ_MC_KI_ant('Bruttoköp'& Chr(44) &'EEA,EMU'))

Celambarasan

[IAMDV]

Hi Thomas,

Have you considered using the ASCII character instead ofliteral comma (,)?  I mean you can try touse Chr(44) instead of comma.

Please see the below link for full list of ASCII characters.And Chr() function in QlikView supports ASCII characters.

http://www.asciitable.com/q    

I hope this helps!

Cheers- DV

[#4 · Accepted solution]

A bug, or work as designed, is causing this.

http://community.qlik.com/message/118416#118416

[rbecher]

Set vSales=sum({<Year={$(vYears)}>} Amount);
Set vYears=2011,2012,2013;

And in the chart expression: =$(vSales)

- Ralf