topic Re: Percentage in Pivot Table in QlikView

Percentage in Pivot Table

krishna20 — Wed, 25 Mar 2015 10:17:01 GMT

Hi Friends,

How can we show percentage value in pivot table.

I got result for an expression like

Dimension Expression %for Expression

A 121,911,228 ?

B 225,221,122 ?

C 432,100,101 ?

D 132 ?

E 10 ?

I Have used % in number format,But it shows some exceed value. Please anyone suggest me.

Regards

Krishna

Re: Percentage in Pivot Table

Wed, 25 Mar 2015 10:23:12 GMT

Can you try something like Expression/ TOTAL Expression and in the Number Tab of the Pivote Table select integer and Show in Percentage(%)

Re: Percentage in Pivot Table

krishna20 — Wed, 25 Mar 2015 10:31:36 GMT

Hi Ram,

To use total we need to add Sum, Count, Aggr right?

Re: Percentage in Pivot Table

Wed, 25 Mar 2015 10:34:17 GMT

Krishna,

Can you send me the sample QVW

Re: Percentage in Pivot Table

Wed, 25 Mar 2015 10:44:52 GMT

Hi Krishna,

Select Relative as shown below

Re: Percentage in Pivot Table

krishna20 — Wed, 25 Mar 2015 11:03:54 GMT

Hi Rupas,

Thanks for reply, Is pivot table is having the relative option?

Re: Percentage in Pivot Table

Wed, 25 Mar 2015 11:09:32 GMT

For Pivot..

The expression will be

Sum([Expression ])/Sum(TOTAL [Expression ])

and selected Show in Percent(%) in the number tab

Re: Percentage in Pivot Table

Wed, 25 Mar 2015 11:11:22 GMT

relative is not available in pivot or else you can achieve it by writing expression like below,

=num(sum(sales) /total sales),'#,##0%')

& keep expression default as it is...

Re: Percentage in Pivot Table

krishna20 — Wed, 25 Mar 2015 11:14:11 GMT

Hi,

This is my Expression. Here TREATY_SEC_SHARE is a field which i need to multiply directly.

=((sum(TT_QS_PREM_LC_1)+sum(TT_1S_PREM_LC_1)+sum(TT_2S_PREM_LC_1))*TREATY_SEC_SHARE)

pls help on this

Re: Percentage in Pivot Table

Wed, 25 Mar 2015 11:18:04 GMT

Hi,

Try like below,

=num(((sum(TT_QS_PREM_LC_1)+sum(TT_1S_PREM_LC_1)+sum(TT_2S_PREM_LC_1))*TREATY_SEC_SHARE),'#,##0%')

& keep expression default as it is...

Which field you are using as denominator..

Re: Percentage in Pivot Table

krishna20 — Wed, 25 Mar 2015 11:26:46 GMT

Hi Harsha,

Thank you for your reply. Please find the attached snapshot which i got after applying as u suggested.

Re: Percentage in Pivot Table

Wed, 25 Mar 2015 11:29:26 GMT

Yes,

If your requirement is fulfilled then please close the thread ...

Re: Percentage in Pivot Table

krishna20 — Wed, 25 Mar 2015 11:32:20 GMT

It's not exactly i want Harsha. We can't show percentages in Lakhs. We need to show percentage for 100.

Re: Percentage in Pivot Table

Wed, 25 Mar 2015 11:37:03 GMT

Try like below & see,

=num(

((sum(TT_QS_PREM_LC_1)+sum(TT_1S_PREM_LC_1)+sum(TT_2S_PREM_LC_1))*TREATY_SEC_SHARE)

((sum(total TT_QS_PREM_LC_1)+

sum(total TT_1S_PREM_LC_1)+

sum(totalTT_2S_PREM_LC_1))

sum(total TREATY_SEC_SHARE))

,'#,##0%')

Re: Percentage in Pivot Table

krishna20 — Wed, 25 Mar 2015 11:59:46 GMT

Hi Harsha,

Thank you for the support. A little modification in expression brought my answer.

=num(

((sum(TT_QS_PREM_LC_1)+sum(TT_1S_PREM_LC_1)+sum(TT_2S_PREM_LC_1))*TREATY_SEC_SHARE)

((sum(total TT_QS_PREM_LC_1)+

sum(total TT_1S_PREM_LC_1)+

sum(totalTT_2S_PREM_LC_1))

( TREATY_SEC_SHARE))

,'#,##0%')

Re: Percentage in Pivot Table

Wed, 25 Mar 2015 12:08:55 GMT

it's pleasure please close thread now..

Re: Percentage in Pivot Table

Wed, 25 Mar 2015 12:33:10 GMT

hii

Try this expressions

=num(sum(sales) /total sales),'#,##0%')

Sum([Expression ])/Sum(TOTAL [Expression ])