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

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

paulyeo11 — Wed, 08 Jun 2016 21:22:53 GMT

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

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

paulyeo11 — Wed, 08 Jun 2016 21:23:34 GMT

my QV Doc

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

Anonymous — Thu, 09 Jun 2016 10:44:47 GMT

Hi paul,

Look at this:

Regards!

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

Anil_Babu_Samineni — Thu, 09 Jun 2016 10:58:21 GMT

Paul,

Might be o/p data is different so that if o/p came like that.

It's depends on the Year wise o/p

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

paulyeo11 — Thu, 09 Jun 2016 11:08:07 GMT

Hi Manual

Thank you very much , it work .

I notice you create a expression below for display rEVENUE amount :-

Dual(Sum({<rEVENUE={"rEVENUE"}>}Amount*1),Sum({<rEVENUE={"rEVENUE"}>}Amount*1)

(Sum({<rEVENUE={"rEVENUE"}>}Amount*1)+Sum({<eXP={"eXP"}>}Amount*-1)))

May i know what it the above expression does ? i mean what does the Dual do to the whole expression ? pls share with me.

Paul

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

paulyeo11 — Thu, 09 Jun 2016 11:20:37 GMT

Hi Anil

I don't understand what you try to tell me ? By the way Manuel solution work fine for me , just that i don't understand the expression , and how he make it work.

Paul

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

Anil_Babu_Samineni — Thu, 09 Jun 2016 11:23:15 GMT

Paul,

Time G_D.

I want to know one thing. When ever mouse over goes to the Chart 1 some pop-up came right.

So do you know how to increase that pop up font size, If you know can you please let me know where i need to change the font size of that Pop Up

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

paulyeo11 — Thu, 09 Jun 2016 11:31:05 GMT

Hi Manuel

After success in create the stack chart in QV , i try to do the same for QS.

Chart 1 work fine . Now it display eXP % , I like to make it stack chart , which display rEVENUE and eXP in one bar , total amount add up equal to 100%.

I try to create chart 2 , using the same approach, but it does not work.

Hope some one can advise me,

Paul

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

Anonymous — Thu, 09 Jun 2016 11:33:45 GMT

Hi Paul,

Dual function has two parameters, text and num, Dual(Text,Num). It shows the text on chart, but gives the value to the bar.

Dual(Amount value,% of Amount respect Sum(Amount+Exp))

On Qlik help:

dual( s , x )

Forced association of an arbitrary string representation s with a given number representation x. In QlikView, when several data items read into one field have different string representations but the same valid number representation, they will all share the first string representation encountered. This function can be used in scripts and chart expressions.

In scripting, the dual function is typically used early in the script, before other data is read into the field concerned, in order to create that first string representation, which will be shown in list boxes etc.

Note!
If a dual value is too large to fit in a field object, it will be represented by ## and not truncated with ... like a string.

Regards.

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

paulyeo11 — Thu, 09 Jun 2016 11:35:02 GMT

Hi Anil

You can click on the chart property , and click on Fonts Tab , and go to right size top and change the fonts size from 12 to 20 , it will increase the fonts size.

Paul

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

paulyeo11 — Thu, 09 Jun 2016 11:45:17 GMT

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

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

Anonymous — Thu, 09 Jun 2016 12:33:58 GMT

Hi Paul

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

Regards.

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

paulyeo11 — Thu, 09 Jun 2016 12:37:40 GMT

Hi Manuel

Many thank it work fine,.

Paul

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

Anonymous — Thu, 09 Jun 2016 12:55:55 GMT

Hi paul,

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

Regards.

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

paulyeo11 — Thu, 09 Jun 2016 12:58:21 GMT

Hi Manuel

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

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

paulyeo11 — Thu, 09 Jun 2016 13:02:44 GMT

Hi Manuel

Thank you for your feedback

Paul

Sent from my iPhone

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

Anonymous — Thu, 09 Jun 2016 13:14:29 GMT

Hi Paul,

Your values are:

Exp + Revenue = 1946290285.46

Exp = 571730140.64

Percentage is 29%, it is ok.

Regards

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

paulyeo11 — Thu, 09 Jun 2016 13:32:37 GMT

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

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

Anonymous — Thu, 09 Jun 2016 13:37:38 GMT

Hi Paul,

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

Regards

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

paulyeo11 — Sat, 11 Jun 2016 19:38:48 GMT

‌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