topic Re: Display value on barchart in QlikView

Display value on barchart

Mon, 01 Sep 2014 10:12:54 GMT

Hi guys,

I have some date which looks like this:

Stuff Target Achieved

A 1 1

A 1 0

A 1 1

B 1 1

I need to create a barchart which would tell me what's the percentage of the stuff achieved, thus, in this example the barchart would be like:

A -> 75%

B -> 100%

The problems now is that I want to display values on the chart, but instead of the percentage I want to display the number of stuff achieved in each A and B, so it would be like 3 for A and 5 for B, but I want to keep the percentage from 0 to 100 on the Y Axis. How would I do that?

Thanks,

Adrian

PS: No scrips because I can't open them

Re: Display value on barchart

MK_QSL — Mon, 01 Sep 2014 10:19:31 GMT

Create a Bar Chart

Dimension

Stuff

Expression

SUM(Achieved)/SUM(Target)

Make sure for this expression Bar is Ticked and Values on Data Points Unticked

COUNT({<Achieved = {'>0'}>}Achieved)

Make sure Bar is unticked and Values on Data Points Ticked

Now Go To Number Tab... Select 1st Expression and Tick Fixed To 0/1/2 Decimals (whatever you want to keep)

TIck Show in percentage %

Re: Display value on barchart

Mon, 01 Sep 2014 14:55:30 GMT

For some reason, requirements have changed. Instead of a bar chart, I now have the Combo Chart (Bar+Line). What you said it worked perfectly for bar chart, but it doesn't work for combo chart. Any ideas?

Thanks,
Adrian

Re: Re: Display value on barchart

MK_QSL — Mon, 01 Sep 2014 15:01:45 GMT

It should work....

Make sure that for 2nd expresssion only Values on Data point is ticked...

Re: Display value on barchart

Mon, 01 Sep 2014 15:12:57 GMT

The number on the bar chart is not displayed anymore. i can't open scripts, unfortunately, so could you explain me what's in there?

Thanks,

Adrian

Re: Display value on barchart

MK_QSL — Mon, 01 Sep 2014 15:14:17 GMT

Provide your qvw... i will look into it...

Re: Re: Display value on barchart

Tue, 02 Sep 2014 08:13:38 GMT

Hi,

This is my qvw. Thanks

Re: Display value on barchart

Tue, 02 Sep 2014 08:32:12 GMT

Hi,

Select the combo Chart,

Add Stuif as dimension,

SUM(Achieved)/SUM(Target) as first expression you could see as line chart representation in left corner for the expr

COUNT({<Achieved = {'>0'}>}Achieved) as second expre

In the Number tab for the first expres cick on integer and ennale %

Hope this will help you

Re: Re: Re: Display value on barchart

MK_QSL — Tue, 02 Sep 2014 08:34:54 GMT

FYI

Re: Display value on barchart

Tue, 02 Sep 2014 08:35:34 GMT

Hi,

I did that and it worked perfectly for bar chart. I'm using combo chart now because I need a threshold, which in this case in 100%, but it can vary. Using combo and having the threshold, the number is not shown anymore on the bars (all I did was to "add" a line at the top, at 100%). Any ideas?

Thanks

Re: Display value on barchart

jagan — Tue, 02 Sep 2014 08:42:22 GMT

Hi,

Using Bar chart you can add a reference line for threshold 100% like below

Chart Properties-> Presentation -> Reference Lines-> Add -> Give Expression = 1

Hope this helps you.

Regards,

Jagan.

Re: Re: Re: Display value on barchart

Tue, 02 Sep 2014 08:42:32 GMT

Unfortunately, I can't open it... Could you please tell me what you modified?

Thank you so much for your time, Manish!

Re: Display value on barchart

MK_QSL — Tue, 02 Sep 2014 08:44:26 GMT

Disable Third Expression or Remove it completely

First Expression , only tick Bar and untick Line

Second expression, only tick Values on data point.. .Bar and line should be unticked...

Re: Display value on barchart

Tue, 02 Sep 2014 09:11:35 GMT

Hi,

If I do this, the line would be at the top of the bars. That line should have an expression (the one that was there) and remain "up" regardless the two bars not being at 100%.

Re: Display value on barchart

Tue, 02 Sep 2014 09:12:08 GMT

Hi,

I know I can do that, but I need a fixed expression for the line and still have the numbers on the bars

Re: Display value on barchart

engishfaque — Tue, 02 Sep 2014 09:13:08 GMT

Dear Adrian,

Try this,

Chart Properties > Tab "Expressions" > Un check to "Relative" > Apply > OK.

Kind regards,

Ishfaque Ahmed

Re: Display value on barchart

Tue, 02 Sep 2014 09:14:46 GMT

I want the numbers to be shown on the bar charts

Re: Display value on barchart

Tue, 02 Sep 2014 09:17:31 GMT

before inserting the line which is in the other picture (scroll up a bit), my graph is like this (and it's perfectly correct), but when I insert the line at 100% (which has an expression), the 3 and 6 are not displayed anymore

Re: Display value on barchart

Tue, 02 Sep 2014 09:19:35 GMT

why cant you try for fast type change option

try to convert the existing/correct bar chart to the combo chart and check for the solution

may it works fine for you

Re: Display value on barchart

Tue, 02 Sep 2014 09:23:14 GMT

The chart works fine even if it's a Combo, the problem comes up when I add a third expression (for the threshold line). At the moment, for example, I have just two expression, the chart is Combo (but I have no line in there) and it works fine. As soon as I add the line, the numbers are not displayed anymore