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: 
datagrrl
Creator III
Creator III

Display text values on status chart (Bar, Gauge or Block or ???)

YesNo.PNG

The image above is a mock up from PowerPoint. I can get the chart to work in a Block Chart, Gauge or Bar Chart, but I can't get the text to do what I want. I would like to see the values and the expression label in the chart.

Any suggestions are appreciated. I am guessing the answer is simple and I am just missing it.

I would also like to keep the green on the left and the red on the right if possible.

Thanks in advance for your help.

1 Solution

Accepted Solutions
MarcoWedel

Hi,

one solution could be a stacked bar chart like:

QlikCommunity_Thread_192839_Pic1.JPG

QlikCommunity_Thread_192839_Pic2.JPG

hope this helps

regards

Marco

View solution in original post

9 Replies
Mark_Little
Luminary
Luminary

Hi,

i would use the text in chart option. You can add an expression

='Yes'&Sum(Value)

You can then use Ctrl+shift to re position

Mark

datagrrl
Creator III
Creator III
Author

Exactly! Thanks. I didn't think of looking for a box for the Text in Chart when using Ctrl+Shift.

datagrrl
Creator III
Creator III
Author

Okay, so that works pretty well. Even when I have a small about on the negative side it looks good.

Not so much when I add a third status type.

Looks good when it is even:

Even.PNG

But uneven doesn't look great:

Uneven.PNG

Maybe I didn't quite understand what you were describing.

Mark_Little
Luminary
Luminary

Hi,

Yer that is what i was meaning like you say it isn't great once you start having more than two. I haven't found a good way of making them more dynamic, there isn't a set way or an easier option i am aware of.

Mark

datagrrl
Creator III
Creator III
Author

Okay, thanks so much for your help.

MarcoWedel

Hi,

one solution could be a stacked bar chart like:

QlikCommunity_Thread_192839_Pic1.JPG

QlikCommunity_Thread_192839_Pic2.JPG

hope this helps

regards

Marco

datagrrl
Creator III
Creator III
Author

Okay, I was trying a stacked bar chart, but I must not have had the settings quite right. That is exactly what I am looking for.

datagrrl
Creator III
Creator III
Author

I tried three different options, both of your suggestions an a third one using a block chart. We picked the stacked bar with the text. I added Pop Up text for the sections that are too short for text and it works. Thanks!

MarcoWedel

‌you're welcome

regards

Marco