Announcements
Product Release Webinar: Qlik Insider airing December 6! REGISTER TODAY!
cancel
Showing results for
Did you mean:
Not applicable

Relative pct. in pivottabel

Hi,

I need to know how I can create the following solution in Qlikview.

I have alot of data, therefor I have alot of pivot tabels to simplify the data.

However, I need to add the relative pct. to the tabel - so far without luck.

How can I get my qlikview pivottabel to act as the Excel screenshots below;

Thanks in advance to all of you

/Martin

11 Replies
MVP

Yes you can make charts like attached snap they are pivot tables use pivot charts for this.

Hope this helps

Former Employee

The best way to calculate relative percentages is to use the "total" qualifier. Hence, in your case, you should have two expressions:

Sum(Sales)

Sum(Sales) / Sum(total Sales)

HIC

Not applicable
Author

I know how to make pivot tabels in Qlikview - that was not the question.

The questions was as to how I can make the percentage calculation as shown in the Pictures.

/Martin

Not applicable
Author

Hi Henric,

Thanks for the reply - however, I don't want to create to expressions as my table already have plenty of expression.

Any other suggstions?

/Martin

Former Employee

Then you just use the expressions you want. For the relative number, you should use

Sum(Sales) / Sum(total Sales)

HIC

Not applicable
Author

I your Sum(Sales)  or Sum(total Sales) are callculated in other expressions of the same chart, You may use thems results in another expression (almost like in xls) . U may call it by name (label).

regards

Darek

Not applicable
Author

Hi Again,

Neither of your espressions gives me the result that I wanted.

/Martin

Not applicable
Author

Your suggestions is very simliar to that of Henric - and therefor this doesn't provide the desired result.

/Martin

Not applicable
Author

Some types of charts have "Relative" option. But pivot has not.

I think it is not possible to show values if it has not expression. You most often need also dimension (s) .

Sometimes it may be useful to add artificial dimension to have less expressions. But i don't understand what is the problem of having 1 more epression in your chart?

regards

Darek

Community Browser