$-signed Set analysis expression seems to go beyond selections

googel84 — Wed, 02 Apr 2014 15:22:07 GMT

I recently solved an issue thanks to Gysbert Wassenaar (see Nested aggregation not allowed issue) but the solution brought me to an other doubt, concerning a set analysis that seems to go beyond selections made on document fields.

To be more precise, I have a Year field and the following formulas in a bar chart.

This one to get 2014 YTD sales...

sum({$< DATA_MOV_MAG.ANNO = {$(=$(vAnnoPiuRecente))} >}

     if( inyeartodate(

            DATA_MOV_MAG,

            makedate($(=$(vAnnoPiuRecente)),num(month('$(vDataBase)')),num(day('$(vDataBase)'))),

            0),

       VALORE_EURO,

       0

    )

)

... and this one to get 2013 LYTD sales

sum({$< DATA_MOV_MAG.ANNO = {$(=$(vAnnoPiuRecente)-1)} >}

     if( inyeartodate(

          DATA_MOV_MAG,

          makedate($(=$(vAnnoPiuRecente)-1),num(month('$(vDataBase)')),num(day('$(vDataBase)'))),

          0),

     VALORE_EURO,

     0

)

)

What happens is that I still see values returned by the 2013 formula even if the user selects only one value from the Year field.

How is it possible?

Re: $-signed Set analysis expression seems to go beyond selections

whiteline — Wed, 02 Apr 2014 19:44:49 GMT

Hi.

With set analysis you take current set {$} and modify it overriding the user selections.

If you want to keep the selections use intersection of these sets (refer to help 'set analysis').

topic $-signed Set analysis expression seems to go beyond selections in QlikView

$-signed Set analysis expression seems to go beyond selections

Re: $-signed Set analysis expression seems to go beyond selections