11 Replies Latest reply: Aug 4, 2014 8:12 AM by Francisco Javier Fernandez Morcillo

# 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

• ###### Re: Relative pct. in pivottabel

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

Hope this helps

• ###### Re: Relative pct. in pivottabel

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

• ###### Re: Relative pct. in pivottabel

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

• ###### Re: Relative pct. in pivottabel

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

• ###### Re: Relative pct. in pivottabel

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

Sum(Sales) / Sum(total Sales)

HIC

• ###### Re: Relative pct. in pivottabel

Hi Again,

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

/Martin

• ###### Re: Relative pct. in pivottabel

Works fine for me, Thanks!!

• ###### Re: Relative pct. in pivottabel

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

• ###### Re: Relative pct. in pivottabel

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

/Martin

• ###### Re: Relative pct. in pivottabel

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

• ###### Re: Relative pct. in pivottabel

Salve,

io ho Usato la Funzione dimensionality (), con la Quale Sono riuscito a trovare il LIVELLO di Aggregazione per le PCT.

Ad Esempio Item.A e Item.B Sono la Dimensione di LIVELLO 1 MENTRE A, AA, AAA e AAAA Sono la Dimensione di livello 2, per cui:

if (dimensionality() = 1, aggr (sum ([SUM AF VENDITA], xxxxx), if(dimensionality() = 2, aggr (sum ([SUM AF VENDITA], yyyyy))

Saluti

Bruno