topic set analysis - ignore one dimension and one selection in QlikView

set analysis - ignore one dimension and one selection

Thu, 01 Dec 2011 17:24:06 GMT

Hello, here is my problem:

I have a pivot table with 2 dimensions (Year-Month and Specialty).

I want to make a sum inside the table ignoring the specialty and the selected day, but not year and month.

To ignore one dimension set analysis would be: sum(<Specialty> total myCounter)

To ignore the selected day: sum($<Day = > myCounter)

But how can I combine both??

swuehl — Thu, 01 Dec 2011 17:32:40 GMT

Set analysis will not consider the dimension value anyway, so I think it could look like:

=sum({$<Day= >} total<Year-Month> myCounter)

Note that I used a total specifier with given dimension, only Year-Month dimension will be used for grouping.

Hope this helps,

Stefan

Thu, 01 Dec 2011 17:58:02 GMT

It works, thanks a lot Stefan!