topic Re: % percent Bar charts in QlikView

% percent Bar charts

manojkulkarni — Wed, 25 Feb 2015 09:05:01 GMT

Hi all,

Below is my data in pivot table format in QV, i would like to show data in percentage next to no of Transactions column. % of each group should be respect Segments and another percentage w.r.t Total.

Same pivot chart also needs to be changed to Bar chart with stacked. Both bars has to be scaled to 100%.

Segment	Group	# of Transactions
Segment1	2-3	313629
	3-4	104418
	>4	993945
Segment2	2-3	462818
	3-4	173109
	>4	1286426

Re: % percent Bar charts

Wed, 25 Feb 2015 09:24:18 GMT

= sum (# of Transactions)

then

in expression tab check -> the relative option

Re: % percent Bar charts

Wed, 25 Feb 2015 09:30:56 GMT

HI Manoj

write another expression as below

=sum(Transactions)/sum( total Transactions)

then go to properties -> Number tab

in that select above expression and in right panel select number or interger or decimal limit and

enable the check box show in %

there you go

Regards

$@M

Re: % percent Bar charts

manojkulkarni — Wed, 25 Feb 2015 09:31:30 GMT

This will not work, as it calculates % on entire data. But my requirement is to calculate % of each group in each segment

Re: % percent Bar charts

jagan — Wed, 25 Feb 2015 09:38:02 GMT

Hi Manoj,

Try this expressions

=Sum(Transactions)/Sum( TOTAL <Segment> Transactions)

Regards,

Jagan.

Re: % percent Bar charts

manojkulkarni — Wed, 25 Feb 2015 09:51:52 GMT

=Sum(Transactions)/Sum( TOTAL <Segment> Transactions)

I tried same expression as you have mentioned, but i had use distinct key in Sum to take unique transactionIds.

With Out distinct it is providing expected result.

In that case, the above formula is not working. Do you have any idea, why is this ?

Re: % percent Bar charts

jagan — Wed, 25 Feb 2015 09:57:48 GMT

Hi,

If you are counting the transactions the use Count() like below

=Count( Distinct Transactions)/Count( TOTAL <Segment> Distinct Transactions)

Regards,

Jagan.

Re: % percent Bar charts

manojkulkarni — Wed, 25 Feb 2015 10:02:18 GMT

Thanks Jagan,

It was my mistake, Relative check box in expression & percentage in number format both were checked. Because of this getting wrong value.

Re: % percent Bar charts

jagan — Thu, 26 Feb 2015 01:55:56 GMT

Hi,

If you are using below expression then you should not select the Relative option

=Count( Distinct Transactions)/Count( TOTAL <Segment> Distinct Transactions)

If you got the solution please close this thread by giving Correct and Useful answers to the posts which helps you.

Regards,

Jagan.