topic escape character in parameter for set analysis in QlikView

escape character in parameter for set analysis

Wed, 22 Feb 2012 10:48:06 GMT

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 — Wed, 22 Feb 2012 11:02:38 GMT

Hi,

Try this.

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

Celambarasan

IAMDV — Wed, 22 Feb 2012 11:13:18 GMT

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.

I hope this helps!

Cheers- DV

Wed, 22 Feb 2012 12:52:40 GMT

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

rbecher — Thu, 23 Feb 2012 20:58:33 GMT

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

And in the chart expression: =$(vSales)

- Ralf