topic Re: Formatting Text ( Align - RIGHT) in bar chart in QlikView

Formatting Text ( Align - RIGHT) in bar chart

vikasmahajan — Mon, 18 Nov 2013 06:08:42 GMT

Dear All

I have bar chart I want to format text in left align please refer attached jpg for help.

How to format text '<b>' using this we can BOLD text , How to align right / left in qlikview.

Thanks

Vikas

Re: Formatting Text ( Align - RIGHT) in bar chart

Mon, 18 Nov 2013 06:34:51 GMT

Hi Vikas,

1. For making the Text Bold follow this,

go to Chart properties > Axes (Tab) > Dimension Axis (block) > Font (Button) >

from here you can change the text to bold, italic, size ,etc....

and

2. For alignment of text.

Diagonally oriented labels in a vertical bar chart ARE right-justified...

I don't think it's possible to control text alignment (left-right-center) in the Chart Labels, - this is controlled by QlikView. The only possible work around I could think of is creating equally sized strings with padded spaces in the beginning or at the end, and selecting a fixed-width (none-true type) font. This way you can "fake" left- or right- justification.

Hope this helps you.

Regards,

Ravikant

Re: Formatting Text ( Align - RIGHT) in bar chart

vikasmahajan — Mon, 18 Nov 2013 09:16:01 GMT

I thing using HTML code it is possible in qlikview is there any Idea to get the same.

Vikas

Re: Formatting Text ( Align - RIGHT) in bar chart

israrkhan — Thu, 21 Nov 2013 12:02:05 GMT

Hi Vikas,

you can align left by going on Axes tab>> Dimension Axes>> uncheck Truncate Label,

it will align left.

Re: Formatting Text ( Align - RIGHT) in bar chart

Thu, 21 Nov 2013 12:28:03 GMT

Hi IsrarKhan,

Sorry i could not find that option Truncate Label.

Do i need to Make changes in Settings or something ?

Re: Formatting Text ( Align - RIGHT) in bar chart

CELAMBARASAN — Thu, 21 Nov 2013 12:48:37 GMT

This is not possible. Alignments like those aren't implemented yet.

Re: Formatting Text ( Align - RIGHT) in bar chart

vikasmahajan — Fri, 22 Nov 2013 03:51:46 GMT

Still now I have not got any solution for this problem ,

Any one have IDEA how to resolve the same.

Vikas

Re: Formatting Text ( Align - RIGHT) in bar chart

sujeetsingh — Fri, 22 Nov 2013 04:25:25 GMT

Hello Vikas,

See the sample and it seems it is the one which you want .

----For Bold i have used option Properties>>Axes>> Dimension Axis>>Font Tab

----For Left Alignment it is to unchek Truncate Label on same AxisTab under Dimension Axis

Re: Formatting Text ( Align - RIGHT) in bar chart

vikasmahajan — Fri, 22 Nov 2013 04:41:56 GMT

Hello

Thanks Sujit I am using Qlikview Version 11 I am not able to see

----For Left Alignment it is to unchek Truncate Label on same AxisTab under Dimension Axis

Option Where is this ?

Vikas

Re: Formatting Text ( Align - RIGHT) in bar chart

sujeetsingh — Fri, 22 Nov 2013 04:46:42 GMT

See the snapshot image

Re: Re: Formatting Text ( Align - RIGHT) in bar chart

Fri, 22 Nov 2013 05:17:24 GMT

Hi sujit,

I am also using Qlikview Version 11 and I am also not able to see that Truncate Label Option

Do we have to make any changes in the Settings..?

see the attached image

Re: Formatting Text ( Align - RIGHT) in bar chart

Fri, 22 Nov 2013 05:26:05 GMT

Hi Vikas,

To my knowledge, you can only use HTML code on expressions to make it as Bold.

Go to expression -> click on '+' sign left side to the expression.

Click on the 3 rd option 'Text Format' from the drop down menu.

and enter the same <b> for bold, <i> for italic .......

Hope this helps you.

Regards,

Pavan.

Re: Formatting Text ( Align - RIGHT) in bar chart

sujeetsingh — Fri, 22 Nov 2013 05:45:50 GMT

Hi Ravi seems it is not in Qv11. But i am too using Qv11 sr3

Try Sttings >>>Document Properties>>> Presentation

Re: Formatting Text ( Align - RIGHT) in bar chart

sujeetsingh — Fri, 22 Nov 2013 05:46:55 GMT

Gentleman if this long thread helped you or satisfied you so update the fact as helpful.

Re: Formatting Text ( Align - RIGHT) in bar chart

Fri, 22 Nov 2013 05:47:28 GMT

Hi Ravi,

Which SR of QV 11 you are using?

Vinoth

Re: Formatting Text ( Align - RIGHT) in bar chart

Fri, 22 Nov 2013 06:04:16 GMT

Hi ,

Qlikview 11.00.11149.0 IR

(Personal Edition)

---

Ravikant

Re: Formatting Text ( Align - RIGHT) in bar chart

Fri, 22 Nov 2013 09:43:50 GMT

Hi Ravi,

QV 11 IR is not having much functions/opritons including Truncate Label.

Suggest you to install the latest QV 11.2 SR4 and test the same.

Vinoth

Re: Formatting Text ( Align - RIGHT) in bar chart

israrkhan — Fri, 22 Nov 2013 11:32:11 GMT

Hi, Ravikant

its bar chart, qlikview 11.2 sr3..

see the image, make sure you have set styling Mode to Advance, in Document Properties.

Re: Formatting Text ( Align - RIGHT) in bar chart

Fri, 22 Nov 2013 12:17:49 GMT

Thank you IsraKhan....!

Re: Formatting Text ( Align - RIGHT) in bar chart

Mon, 19 Oct 2015 17:09:08 GMT

Thanks IsrarKahn! This solved a problem I was having with alignment.