topic Text alignment in a pivot table header in QlikView

Text alignment in a pivot table header

j_nlucas — Mon, 16 Apr 2012 10:06:38 GMT

Hi,

I need to align the header text to the right in a table for an expression name. I included the character chr(13) and after this I can't get the text aligned to the right as you can see in the attached image.

The expression for the expression label is: ='Gross Amount' & Chr(10) & ' £k'

Any idea?

Thank you.

Text alignment in a pivot table header

jagan — Mon, 16 Apr 2012 10:23:59 GMT

Hi,

I given this as label

='Gross Amount' & ' £k'

and set

Chart Properties -> Presentation - > and set Wrap Header Text Header lines as 3 (By default is 2)

Regards,

Jagan.

Text alignment in a pivot table header

j_nlucas — Mon, 16 Apr 2012 10:40:44 GMT

Hi Jagan,

The problem with that is that it only fills two lines even though it is set to three, and there are more fields with the same format and it wouldn't work for all of them as they have different lenght.

Regards

Lucas

Text alignment in a pivot table header

Anonymous — Mon, 16 Apr 2012 10:47:12 GMT

You just look jagan solution

='Gross Amount' & ' £k' ,

He just leave some blank space based on the length.

You just try to use some blank space in the text to wrap the label value into 3 lines.

As the same time fix this too,

Chart Properties -> Presentation - > and set Wrap Header Text Header lines as 3 (By default is 2)

Regards

Ashok

Text alignment in a pivot table header

j_nlucas — Mon, 16 Apr 2012 11:31:32 GMT

Hi Ashok thanks for your reply. I am afraid that that does not solve the problem either...

Text alignment in a pivot table header

rajni_batra — Mon, 16 Apr 2012 11:50:01 GMT

Is the alignment of header in right in presentation tab also not working???

Re: Text alignment in a pivot table header

Anonymous — Mon, 16 Apr 2012 11:52:07 GMT

Hope the attached file will be solve your doubt

Regards

Ashok

Re: Text alignment in a pivot table header

rajni_batra — Mon, 16 Apr 2012 12:02:25 GMT

anything wrong with this??

Re: Text alignment in a pivot table header

Anonymous — Mon, 16 Apr 2012 12:27:00 GMT

This is(attached Image) you want right and i hope i solve your problem.

Regards

Ashok

Text alignment in a pivot table header

j_nlucas — Mon, 16 Apr 2012 12:40:24 GMT

Hi Ashok, is that gap at the right of the word "amount" in your file and mine, what I am trying eliminate. Regards

Text alignment in a pivot table header

j_nlucas — Mon, 16 Apr 2012 12:44:59 GMT

Hi Ashok. Yes that's what I need but I can't get that from your qvw... How did you do it?

Text alignment in a pivot table header

Anonymous — Mon, 16 Apr 2012 12:46:31 GMT

Please check once more .

I think there is no space after the Amount.

still you have any issue in that please attach some sample file to understand your exact problem and try to fix it.

Regards

Ashok

Re: Text alignment in a pivot table header

j_nlucas — Mon, 16 Apr 2012 12:56:12 GMT

Hi Ashok Attached is what I get from your file.

Regards

Lucas

Re: Text alignment in a pivot table header

j_nlucas — Tue, 17 Apr 2012 08:43:33 GMT

Hi all. I fixed it by intalling RS1 for v11.