How to make all my bar chart same height , so that i can view the % changes over the year

[paulyeo11]

Hi All

mY cHART 1 now is correct , but i am not able to make the bar all same height.

Hope some one can advise me.

Paul

[paulyeo11]

Hi Manuel

Thank you very much for your explain on how to use dual .I have remove the Dual , because i don't want it display the amount , instead i try to display the % on the bar , Any idea ?

Paul

[Anonymous]

Hi Paul

Change dual function by % calculation. On number tab select number format in percent.

Regards.

[paulyeo11]

Hi Manuel

Many thank it work fine,.

Paul

[Anonymous]

Hi paul,

On QS you can't show values by column on stacked bar chart.

Regards.

[paulyeo11]

Hi Manuel

After i convert the number to % , now the % return 29% , it should be 42%. Any idea where go wrong ?

[paulyeo11]

Hi Manuel

Thank you for your feedback

Paul

Sent from my iPhone

[Anonymous]

Hi Paul,

Your values are:

Exp + Revenue = 1946290285.46

Exp = 571730140.64

Percentage is 29%, it is ok.

Regards

[paulyeo11]

Hi Manuel

You are right base ,for  Exp / (Exp + Revenue)

But I need to compute  Exp / Revenue not Exp / (Exp + Revenue)

I try to modify the expression , the Bar become some short some long.

Paul

[Anonymous]

Hi Paul,

Then your expression must be Sum({<eXP={"eXP"}>}Amount*-1)/Sum({<rEVENUE={"rEVENUE"}>}Amount*1)

Regards

[paulyeo11]

‌Hi Manuel

I Have try to look at your 2 expression , one is take care of create the rEVENUE amount , and another on eXP

And in order to make the bar same height , you compute both amount with total sum of rEVENUE and eXP

MY imagination to make the ratio base on eXP vs REVENUE by using eXP/rEVENUE is should be very simple , but no matter which way I try I still cannot get the % I want.

my last request to you , it is possible you show me how you do it by using my QV doc ?

PAul