topic Set Analysis ignoring a parameter (Point-in-Time) in QlikView

Set Analysis ignoring a parameter (Point-in-Time)

cristian_av — Fri, 29 Aug 2014 16:02:43 GMT

Hi. I'm using a set analysis for "Time-in-Report"

When I use part of the expression as a Variable, it works as expected. But I when change the variable for the variable content, it just ignored the Cal_ID_MesAnoEP.

Can anybody tell me what am I doing wrong?

Thank you!!

This is the expression WITH the variable

=Sum({$<Cal_ID_MesAnoEP={'$(eLastMonth)'}>}

CantidadServicios)

With the variable eLastMoth defined as:

=Max(Cal_ID_MesAnoEP)

But If I do the Same, but without the variable:

=Sum( {$<Cal_ID_MesAnoEP={'=Max(Cal_ID_MesAnoEP)'}>}	CantidadServicios)
=Sum( {$<Cal_ID_MesAnoEP={"=Max(Cal_ID_MesAnoEP)"}>}	CantidadServicios)

QV just ignore the Cal_ID_MesAnoEP parameter.

Re: Set Analysis ignoring a parameter (Point-in-Time)

Fri, 29 Aug 2014 16:08:45 GMT

=Sum( {$<Cal_ID_MesAnoEP={"$(=Max(Cal_ID_MesAnoEP))"}>}CantidadServicios)

Could u please try the expression show above?

Re: Set Analysis ignoring a parameter (Point-in-Time)

cristian_av — Fri, 29 Aug 2014 16:10:52 GMT

It worked!!

Thank you! damn dollar sign hehe

Re: Set Analysis ignoring a parameter (Point-in-Time)

Fri, 29 Aug 2014 16:11:40 GMT

Hi,

Please try this

Sum({$<Cal_ID_MesAnoEP={"$(=Max(Cal_ID_MesAnoEP))"}>} CantidadServicios)