topic Re: DATA Representing in percentages in QlikView

DATA Representing in percentages

Tue, 27 May 2014 04:59:58 GMT

Hi,

Can any body help me experts.

i have a object like

But i need to display the percentages means John Greg value = 15,173,907. i can be represented in what percentage in 100%.

Anonymous — Tue, 27 May 2014 05:03:54 GMT

Hi,

let the expression in the bar chart be (value/sum(Total value)) * 100.

HTH.

Ravi N.

Tue, 27 May 2014 05:14:41 GMT

Hi, Actually in this bar chart i use the expression

Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>} Sales / $(vCurrency))

Then how can i do the percentage representation

rwunderlich — Tue, 27 May 2014 05:18:08 GMT

Check the "relative" property in the Expression definition.

-Rob

Tue, 27 May 2014 05:28:59 GMT

Hi Rob Wunderlich,

sorry i can't understand

Can you please explain briefly???

anbu1984 — Tue, 27 May 2014 05:52:45 GMT

Select Relative checkbox in Expressions tab

CELAMBARASAN — Tue, 27 May 2014 06:02:17 GMT

You could use relative option or

Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>} Sales) / Sum({$<Year={$(=Max(Year)), $(=Max(Year)-1)}>}TOTAL Sales)

and check the percentage in number format tab.

Tue, 27 May 2014 06:07:33 GMT

you can check the Relative checkbox in Expression tab of properties and all the number will be shown in percentage.

Anonymous — Tue, 27 May 2014 06:09:49 GMT

Hi,

It works either way. U can either select relative tab or u can use an expression that outputs a percentage..

Regards,

Ravi N.

Tue, 27 May 2014 06:23:37 GMT

Hi Celambarasan Adhimulam.

Thank you So much i got the answer

Thank you all for helping me..