Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Certification Exam Sale - 40% off. Register by June 30, 2020. GET DETAILS
Highlighted
Partner
Partner

Disregard a Dimension in calculation in a Pivot Table

Hello,

I really need your help in the following case:

This is an example of my Pivot table:

Item\CategoryCategory1Category2
Item1sum(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

1 Solution

Accepted Solutions
Highlighted
MVP
MVP

Re: Disregard a Dimension in calculation in a Pivot Table

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

View solution in original post

2 Replies
Highlighted

Re: Disregard a Dimension in calculation in a Pivot Table

Try this:

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

Highlighted
MVP
MVP

Re: Disregard a Dimension in calculation in a Pivot Table

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

View solution in original post