topic Re: Chart Titles in QlikView

Chart Titles

cupelix-qlik — Wed, 08 Apr 2015 12:16:02 GMT

I have a chart that i have put a dynamic title on which has multiple calculations as well as some static text.

So an example would be

75%@ 00:07:54 - Missed by 11 Red 2 Incident | Long Waits Over 30 Mins: 12 | Total Incidents: 4350

The Red numbers above are the calculated fields where the blue text is the static text.

What I would like to do is have my chart title to show like this or maybe in 2 other colours.

Is there a way to do this. I can change the colour of the whole text but how (if possible) can you change sections without overlaying addition text as this is to be exported.

Re: Chart Titles

pokassov — Wed, 08 Apr 2015 12:21:47 GMT

Hello, Lee!

You can use text objects instead of chart titles.

You can fill your first text object with static text and set layer more then chart to allow text object to be above chart.

Then you can add the others text objects and calculate your "red text" there. Set layer more then first text object.

Sergey

Re: Chart Titles

sunny_talwar — Wed, 08 Apr 2015 12:26:13 GMT

In short what Сергей Покасов mean is that there is no straight forward way to do it. You will have to use a work around like the one he mentioned.

Best,

Sunny

Re: Chart Titles

cupelix-qlik — Wed, 08 Apr 2015 12:35:07 GMT

Thanks guys, so basically it can't be done. unless I want ot build lots of texts objects per chart as I have more than i chart that i wanted to use this on.

Re: Chart Titles

sunny_talwar — Wed, 08 Apr 2015 12:36:05 GMT

Yup! you are bang on target

Re: Chart Titles

Wed, 08 Apr 2015 13:01:38 GMT

Hi Lee,

Instead of creating multiple text objects with various colors of text that interest you, you may use the extension called: MinimalisticHtmlTextBox.

This extension, are visible in web mode or on the server, allows you to enter html code by which you can build your string with the various calculations and format it as you see fit, thus obtaining a single object.

On the chart enter the same title as the extension above, and overlay the object.
So when you export, the title without the various colors, will still be exported.

Regards

Re: Chart Titles

Wed, 08 Apr 2015 13:03:08 GMT

Link to extension:

QlikTip #39: Displaying Html content within QlikView (Minimalistic HtmlTextBox Object Extension)