topic Re: Display text values on status chart (Bar, Gauge or Block or ???) in QlikView

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

datagrrl — Tue, 24 Nov 2015 16:48:19 GMT

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.

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

Mark_Little — Tue, 24 Nov 2015 17:13:02 GMT

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

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

datagrrl — Tue, 24 Nov 2015 17:19:49 GMT

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

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

datagrrl — Tue, 24 Nov 2015 19:00:26 GMT

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:

But uneven doesn't look great:

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

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

Mark_Little — Tue, 24 Nov 2015 19:06:06 GMT

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

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

datagrrl — Tue, 24 Nov 2015 19:17:03 GMT

Okay, thanks so much for your help.

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

MarcoWedel — Wed, 25 Nov 2015 00:14:19 GMT

Hi,

one solution could be a stacked bar chart like:

hope this helps

regards

Marco

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

datagrrl — Wed, 25 Nov 2015 15:20:48 GMT

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.

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

datagrrl — Wed, 25 Nov 2015 17:55:11 GMT

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!

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

MarcoWedel — Wed, 25 Nov 2015 19:59:09 GMT

‌you're welcome

regards

Marco