Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Pivot Table Set Analysis not ignoring dimension

I have a Pivot Table with "Detailed Industry" and "Band" are Dimensions.

Two Expressions:

  • One gives me # of Claims by Detailed Industry AND Band This works:

=(sum([Claim Count]))

  • Another Gives me # of Claims By Detailed Industry only (ignoring the band) This gives me the SAME number as above, like the set analysis is being ignored

=(sum({<Band =>}[Claim Count]))

What am I missing?!

1 Solution

Accepted Solutions
Highlighted
Creator III
Creator III

Re: Pivot Table Set Analysis not ignoring dimension

Hello.

If you make a selection on a Band, you will see the expressions giving diferent values: some will be zero. Set analysis will ignore the selection but not the chart dimensions. Maybe what you want for the second expression is this:

Sum(Total<[Claim Count]> [Claim Count])


This expression will ignore all chart dimensions EXCEPT [Claim Count].


Hope it helps.

View solution in original post

3 Replies
Highlighted
Creator III
Creator III

Re: Pivot Table Set Analysis not ignoring dimension

Hello.

If you make a selection on a Band, you will see the expressions giving diferent values: some will be zero. Set analysis will ignore the selection but not the chart dimensions. Maybe what you want for the second expression is this:

Sum(Total<[Claim Count]> [Claim Count])


This expression will ignore all chart dimensions EXCEPT [Claim Count].


Hope it helps.

View solution in original post

Highlighted
Not applicable

Re: Pivot Table Set Analysis not ignoring dimension

That's it, although I need the Claim Count BY Detailed Industry so I did this and it seems to work:

=Sum(Total<[Claim Count],[Detailed Industry]> [Claim Count])

Highlighted
Creator III
Creator III

Re: Pivot Table Set Analysis not ignoring dimension

Sorry, I pasted the wrong field name. I realy meant [Detailed Industry]. The correct expression is:

Sum(Total<[Detailed Industry]> [Claim Count])


There is no need to use [Claim Count] as a modifier for the Total qualifier.