topic Re: Text inside a bar in a bar chart in QlikView

Text inside a bar in a bar chart

Thu, 07 Jan 2016 20:47:14 GMT

Hi Qlik Gurus,

I was just wondering if it's possible to display some kind of text inside a bar in a bar chart.

The text is common for all the bars and has no calculation or anything like that.

Suggestions greatly appreciated.

Regards,

Sachin

Re: Text inside a bar in a bar chart

sunny_talwar — Thu, 07 Jan 2016 20:53:53 GMT

Something like this?

Update: Settings changed:

On Expressions Tab:

On Presentation tab:

Re: Text inside a bar in a bar chart

Thu, 07 Jan 2016 20:56:18 GMT

Yeah that is what I want, but I already have a calculation for those bars as well.

Re: Text inside a bar in a bar chart

Thu, 07 Jan 2016 20:56:49 GMT

Can you send me a sample?

Re: Text inside a bar in a bar chart

sunny_talwar — Thu, 07 Jan 2016 20:57:25 GMT

Ya you just need to add another expression -> 'FORECAST'. I have made updates to my previous post above

Re: Text inside a bar in a bar chart

sunny_talwar — Thu, 07 Jan 2016 20:57:55 GMT

Sample is attached here -> Re: Text inside a bar in a bar chart

Re: Text inside a bar in a bar chart

maxgro — Thu, 07 Jan 2016 20:58:47 GMT

maybe this

add another expression with dual ('forecast', repeatthefirstexpression)

in presentation tab

- vertical

- plot value inside segments

in number tab for 2nd expression

- expression default

Re: Text inside a bar in a bar chart

Thu, 07 Jan 2016 21:18:33 GMT

Hi Sunny,

I like the idea but its creating some new issues in my case. I made a few bars invisible. But the text becomes enabled for those bars too and secondly I want the actual vales on data points as well.

Regards,

Sachin

Re: Text inside a bar in a bar chart

Thu, 07 Jan 2016 21:19:34 GMT

Hi Max,

I like the idea but its creating some new issues in my case. I made a few bars invisible. But the text becomes enabled for those bars too and secondly I want the actual vales on data points as well.

Appreciate your prompt and quick reply.

Re: Text inside a bar in a bar chart

Anonymous — Thu, 07 Jan 2016 21:29:09 GMT

Swerving you question, I would just put the word Forecast once in the Chart Title.

Repeating it in every bar is, to my eye, chartjunk as Edward Tufte would say.

Re: Text inside a bar in a bar chart

Thu, 07 Jan 2016 21:31:27 GMT

Hi Bill so did I but the client says it's not visually understandable for a layman.

Re: Text inside a bar in a bar chart

Anonymous — Thu, 07 Jan 2016 21:48:05 GMT

Fair cop.

Re: Text inside a bar in a bar chart

sunny_talwar — Thu, 07 Jan 2016 21:49:14 GMT

Is the issue with invisible bar resolved? You selected correct answer which confuses me

Re: Text inside a bar in a bar chart

Thu, 07 Jan 2016 22:25:03 GMT

Not yet but I guess I can handle it.

Thanks,

Sunny