topic Coma Dynamic Chart in QlikView

Coma Dynamic Chart

Thu, 16 Feb 2012 18:47:48 GMT

Hi,

I'm developing a dynamic chart but I have a problem with the expressions with coma, here is part of my in line expressions table:

ExpName, Expression

Consultas,COUNT({<DS_PROMOCION,CD_PROMOCION>}DISTINCT CD_CONSULTA)

Usuarios, COUNT(DISTINCT CD_USUARIO)

Pedidos,COUNT(DISTINCT CD_PEDIDO)

;

The first one doesn't work because of the coma between DS_PROMOCION and CD_PROMOCION, I've tried using chr(44) but nothing...

I'm using QV10,

Any idea???

Cheers,

David

Thu, 16 Feb 2012 18:52:36 GMT

Use excel or another source instead of inline.

Thu, 16 Feb 2012 20:26:40 GMT

Thanks cisco,

I've found another way, using variables....

Thu, 22 Nov 2012 15:48:18 GMT

Hi dperte85,

got the sam trouble, could you explain how did you use variables to solve this problem ?

thanks a lot,

regards