topic Re: Relative pct. in pivottabel in QlikView

Relative pct. in pivottabel

Mon, 31 Mar 2014 12:14:12 GMT

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

its_anandrjs — Mon, 31 Mar 2014 12:28:52 GMT

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

hic — Mon, 31 Mar 2014 12:38:06 GMT

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

Tue, 01 Apr 2014 07:16:20 GMT

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

Tue, 01 Apr 2014 07:18:46 GMT

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

hic — Tue, 01 Apr 2014 09:55:11 GMT

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

Tue, 01 Apr 2014 10:07:46 GMT

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

Tue, 01 Apr 2014 10:12:16 GMT

Hi Again,

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

/Martin

Re: Relative pct. in pivottabel

Tue, 01 Apr 2014 10:13:04 GMT

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

/Martin

Re: Relative pct. in pivottabel

Tue, 01 Apr 2014 10:50:55 GMT

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

Thu, 10 Jul 2014 11:27:16 GMT

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

Re: Relative pct. in pivottabel

Mon, 04 Aug 2014 12:12:13 GMT

Works fine for me, Thanks!!