Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

set analysis - ignore one dimension and one selection

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??

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

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

View solution in original post

2 Replies
Highlighted
MVP
MVP

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

View solution in original post

Highlighted
Not applicable

It works, thanks a lot Stefan!