topic Re: Set analysis and expression in QlikView

Set analysis and expression

Tue, 16 Sep 2014 16:01:55 GMT

Hi there,

Can someone tell me what´s going wrong with this expression? I get an ok in the expresion but is no reporting any data, although both expressions (numerator & denominator) separately give a value.

=count({<"Year([Fecha de Entrada]"={"Year(Today()"}>} [Línea de ped de Compra])/count(DISTINCT(Month([Fecha de Entrada])))

Thanks in advance and regards.

Asier

Re: Set analysis and expression

Tue, 16 Sep 2014 17:31:19 GMT

Try something like,

count(If(Year([Fecha de Entrada])=Year(Today()), [Línea de ped de Compra]/count(DISTINCT(Month([Fecha de Entrada]))))

Hope it helps

Re: Set analysis and expression

jerem1234 — Tue, 16 Sep 2014 17:52:18 GMT

You can't have expressions as fields in set analysis like {<year(Date) = {'2014'}>}.

Try this code:

count({<[Fecha de Entrada]={"=Year([Fecha de Entrada])=Year(Today())"}>} [Línea de ped de Compra])/count(DISTINCT Month([Fecha de Entrada]))

Hope this helps!

Re: Set analysis and expression

Tue, 16 Sep 2014 18:01:28 GMT

try this

=count({<Year(date([Fecha de Entrada]))={'$(=Year(Today())'}>} [Línea de ped de Compra])/count(DISTINCT(Month(date([Fecha de Entrada]) )))

Re: Set analysis and expression

Tue, 16 Sep 2014 18:40:48 GMT

Thanks all.

But with the count function at the beguining I get an error message and without it the result is - when the result should return 135.000 / 12.

With the other example I get the same result -

If I calculate both expressions separately I get the result.

Should I define variable for this?

Thanks

Re: Set analysis and expression

Tue, 16 Sep 2014 18:41:31 GMT

Thanks all.

But with the count function at the beguining I get an error message and without it the result is - when the result should return 135.000 / 12.

With the other examples I get the same result -

If I calculate both expressions separately I get the result.

Should I define variable for this?

Thanks