topic Re: Disregard a Dimension in calculation in a Pivot Table in QlikView

Disregard a Dimension in calculation in a Pivot Table

nancy_sbeity — Wed, 25 Nov 2020 16:16:04 GMT

Hello,

I really need your help in the following case:

This is an example of my Pivot table:

Item\Category	Category1	Category2
Item1	sum(Sales in Category1 and Item1) / sum(Sales in all the categories and In Item 1)	...
Item2	...	...

So My purpose is to get the sum of sales of each row and column, divided by the sum of sales of the row in all the columns.

I used the following measure: sum(Sales) / sum({1<Category= >}Sales) but I didn't get the right answers.

Any idea?

Thank you in Advance,

Nancy

Re: Disregard a Dimension in calculation in a Pivot Table

sunny_talwar — Fri, 11 Mar 2016 18:47:25 GMT

Try this:

sum(Sales) / sum(TOTAL <Category> Sales)

Re: Disregard a Dimension in calculation in a Pivot Table

swuehl — Fri, 11 Mar 2016 21:40:47 GMT

Sum(Sales) / Sum(TOTAL<Item> Sales)

TOTAL qualifier is essentially telling QV to disregard all dimensions, by adding an optional field list in angle brackets, these fields will still be regarded (and I understand that you still want to regard Item dimension).