topic Re: Image and text (alignment, format, colour) on Chart in QlikView

Image and text (alignment, format, colour) on Chart

Fri, 05 Jul 2013 07:56:56 GMT

Hi Experts,

Is it possible for us to bold the title "We're the Millers" only? (please see figure 1)

The requirement look is like figure 2

The easier way is using pivot table, but the outcome looks like the first figure. I am unable to highlight the title, proper alignment for details and colour the detail.

Another way is using container but it would be quite complicated. Hard to arrange title, detail, figure in such manner.

Kindly advise.

Best regards,

csy

Re: Image and text (alignment, format, colour) on Chart

nizamsha — Fri, 05 Jul 2013 08:06:51 GMT

in general--->title settting is there there u can change the chart font size and color the font and alignment of text left or right

Re: Image and text (alignment, format, colour) on Chart

Mon, 08 Jul 2013 07:25:26 GMT

This will change the color or bold the whole description. I just want to bold the title "We're Millers" but not the whole description, where both title and description get from the same cell in excel raw data.

Re: Image and text (alignment, format, colour) on Chart

Mon, 08 Jul 2013 07:29:11 GMT

I tried with this, but fail to bold only certain words.

For example, there is "abcdefg" in the column,

can we bold only abc, so it will show "abcdefg"?

My following code is not working:

if(Description=

'abc*', '<b>’('abc'))

Re: Image and text (alignment, format, colour) on Chart

Gysbert_Wassenaar — Mon, 08 Jul 2013 07:33:05 GMT

A cell in Qlikview can have only one text format. A textbox in Qlikview can also have only one text format. You'll have to use several textboxes to get the effect you want. Or you can try using an extension object.

Re: Image and text (alignment, format, colour) on Chart

Mon, 08 Jul 2013 07:40:27 GMT

Thanks for this hint, then would you recommend any suitable sheet object?
Container can be aligned in this position?
In fact not only one movie will show, will have a movie list, and they will be filtered according to date selection.

So I cannot use several textboxes and fix their position.

Re: Image and text (alignment, format, colour) on Chart

Stefan_Walther — Fri, 08 Nov 2013 17:51:24 GMT

You could also use the following extension I have created (a bit tricky because you need to know the syntax and Html + CSS), but quite powerful.

http://www.qlikblog.at/1727/formatting-qlikview-data-the-web-way-qtemplate-object-extension/

Regards

Stefan

Re: Image and text (alignment, format, colour) on Chart

Mon, 14 Apr 2014 21:28:53 GMT

Hey Stefan,

Unfortunately, your suggestion doesn't work in SR5... However it's great!

Thanks.

Re: Image and text (alignment, format, colour) on Chart

Wed, 27 Aug 2014 07:42:35 GMT

Hi Stefan,

I need help with the extension. For some reason, External Template is not working. Only works if I use direct template (paste de code inside....)

Many thanks.