topic Pivot Table Set Analysis not ignoring dimension in QlikView

Pivot Table Set Analysis not ignoring dimension

Fri, 01 Aug 2014 17:59:37 GMT

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

Re: Pivot Table Set Analysis not ignoring dimension

Anonymous — Fri, 01 Aug 2014 18:48:59 GMT

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.

Re: Pivot Table Set Analysis not ignoring dimension

Fri, 01 Aug 2014 18:52:53 GMT

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])

Re: Pivot Table Set Analysis not ignoring dimension

Anonymous — Fri, 01 Aug 2014 18:56:26 GMT

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.