topic Re: Issue with a set expression into a If function in QlikView

Issue with a set expression into a If function

javier_florian — Wed, 30 Oct 2013 19:04:18 GMT

Hi Everyone,

Anyone knows why the second expression doesn't work? The app have a filter in front-user to select monetary values or quantity and we show a graph with the follow expressions in the last two months:

Values: =Sum({<Mes={">=$(=Num(Max(Mes))-1)<=$(=Num(Max(Mes)))"}>} Emisiones.ValorPrimaNeta)/Millones

Quantity: =If(Productos.Emite_doble_certificado='Si', Count({<Mes={">=$(=Num(Max(Mes))-1)<=$(=Num(Max(Mes)))"}>} Distinct Emisiones.Certificado)/2, Count({<Mes={">=$(=Num(Max(Mes))-1)<=$(=Num(Max(Mes)))"}>} Distinct Emisiones.Certificado))

With values I don't have any problem... but with quantity @#!"!!

Thanks in advanced.

- Javier Florián

Re: Issue with a set expression into a If function

Anonymous — Wed, 30 Oct 2013 19:21:12 GMT

Javier,

I don't see any problems with the expression itself, except I'd write it shorter:

Count({<Mes={">=$(=Num(Max(Mes))-1)<=$(=Num(Max(Mes)))"}>} Distinct Emisiones.Certificado)

If(Productos.Emite_doble_certificado='Si', 2, 1)

To make sure, try only this part, see if it works

Count({<Mes={">=$(=Num(Max(Mes))-1)<=$(=Num(Max(Mes)))"}>} Distinct Emisiones.Certificado)

Maybe the problem is with the data, not with expression(?)

Regards,

Michael

Re: Issue with a set expression into a If function

javier_florian — Thu, 31 Oct 2013 14:48:05 GMT

Hi Michael,

Thanks for your support!!