Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
cristian_av
Contributor III

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

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.

1 Solution

Accepted Solutions
Highlighted
Not applicable

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

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

Could u please try the expression show above?

View solution in original post

3 Replies
Highlighted
Not applicable

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

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

Could u please try the expression show above?

View solution in original post

Highlighted
cristian_av
Contributor III

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

It worked!!

Thank you! damn dollar sign hehe

Highlighted
Not applicable

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

Hi,

Please try this

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