Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
MK_QSL
MVP
MVP

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
Author

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

MK_QSL
MVP
MVP

It should work....

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

Not applicable
Author

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

MK_QSL
MVP
MVP

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

Not applicable
Author

Hi,

This is my qvw. Thanks

Not applicable
Author

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

MK_QSL
MVP
MVP

FYI

Not applicable
Author

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