topic Re: Chart label modification in QlikView

Chart label modification

Thu, 19 Jun 2014 05:36:57 GMT

hi,

I need to fit the labels below bar chart shown in figure, for example on 1st bar (Renewal Premium Cheque Pick up-cc ) i need to adjust it as

Renewal Premium

Cheque Pick up-cc one below another .??

Re: Chart label modification

whiteline — Thu, 19 Jun 2014 06:06:44 GMT

Hi.

Select the chart then press and hold Ctrl+Shift.

Now the red boarders are shown and you can move the objects within the chart.

Re: Chart label modification

sujeetsingh — Thu, 19 Jun 2014 06:09:33 GMT

Whiteline has told you the option just play with it

Re: Chart label modification

sushil353 — Thu, 19 Jun 2014 06:11:21 GMT

Hi,

you can also change the orientation of the chart.. for the label's having lengthy names .. it is preferable to make the chart in horizontal way..

you can change the chart orientation from style tab of chart properties.

HTH

Sushil

Re: Chart label modification

Thu, 19 Jun 2014 06:48:51 GMT

hi whiteline i tried press and hold Ctrl+Shift. option but unable to get

Renewal Premium

Cheque Pick up-cc in

Re: Chart label modification

perumal_41 — Thu, 19 Jun 2014 06:55:19 GMT

can post sample application

Re: Chart label modification

rwunderlich — Thu, 19 Jun 2014 06:58:47 GMT

You want your labels to split multiline. You can only display multiline labels when you select the diagonal format "/" on the Axes property pane. And you must split them into multi line yourself. It's easiest to do this in the script.

See this post for how to split them in the script.

Displaying long labels on chart X-axis

-Rob

Re: Chart label modification

whiteline — Thu, 19 Jun 2014 07:14:42 GMT

Sorry, not noticed that it's a chart label not the floating text.

Look at the solution Rob's posted below.

Re: Chart label modification

Anonymous — Thu, 19 Jun 2014 07:34:57 GMT

Hi,

You can't split labels in multiple line horizontally, however if you have fix category or want to show top 5 label you can use FirstSortedValue() function to calculate label and use "Text in Chart" option to show on chart. Please Note, you have to align these labels properly on the chart and unchecked show legend option to make it real bar chart.

Below chart shows top 3 constraint plan in horizontal multiline.

Thanks

Re: Chart label modification

rwunderlich — Thu, 19 Jun 2014 07:46:33 GMT

Can you attach a sample QVW that demonstrates this?

-Rob

Re: Re: Chart label modification

Anonymous — Thu, 19 Jun 2014 08:59:44 GMT

Hi Rob,

Here you go..

Thanks

Re: Chart label modification

veidlburkhard — Thu, 19 Jun 2014 09:29:05 GMT

Hi Satyadev,

this is a very sophisticated solution.

But why don't we use horizontal bars, instead? - the very easy solution:

Burkhard

Re: Chart label modification

Thu, 19 Jun 2014 09:39:00 GMT

thank a ton rob, this is exactly what i need

Re: Re: Chart label modification

Anonymous — Thu, 19 Jun 2014 09:50:09 GMT

Hi Burkhard,

You are absolutely right but sometime it is very difficult to convince our client. They just want to see what they have been seeing from long time .

Thanks