Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Display value on barchart

Hi guys,


I have some date which looks like this:

Stuff     Target     Achieved

A          1               1

A          1               1

A          1               0

A          1               1

B          1               1

B          1               1

B          1               1

B          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

26 Replies

Re: Display value on barchart

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 %

Not applicable

Re: Display value on barchart

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

It should work....

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

Not applicable

Re: Display value on barchart

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

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

Not applicable

Re: Re: Display value on barchart

Hi,

This is my qvw. Thanks

Not applicable

Re: Display value on barchart

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

FYI

Not applicable

Re: Display value on barchart

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

Community Browser