9 Replies Latest reply: Feb 4, 2015 6:24 AM by Mayil Vahanan Ramasamy

# customized alighment of the column fields(text) in Pivot table

Hi All,

I have a column say " col1 "  having values A1, A2, A3 coming from a inline table.

The requirement is to align A1, A2 to the left and  A3 to the Right.

How can I do this please suggest.

• ###### Re: customized alighment of the column fields(text) in Pivot table

Could you give more details, please?

Do you require column A3 to be on the right hand side of the Pivot Table.

So you would have Dimensions, Expression(s), and Dimension?

• ###### Re: customized alighment of the column fields(text) in Pivot table

Hi Gizzel,

As per my knowledge, for each content we cannot make a different alignment .

One thing you can do is keep A1 and A2 as text and A3 content as number then in the presentation

you will get the choice to align text and number.

Hope this helps you

• ###### Re: customized alighment of the column fields(text) in Pivot table

Hi

Can we define the values of inline table as "text"  or "number",

how do we do that??

• ###### Re: customized alighment of the column fields(text) in Pivot table

Actually , "col1" is the dimension having text values-A1,A2,A3,A4...

So I  want to customize the alignment of the  the values of the col1 .

hope this makes my question more clear.

• ###### Re: customized alighment of the column fields(text) in Pivot table

Hi

Suppose, if you need to show one of the filed value in right alignment. Then Try like this

LOAD  if(Field = 'A3', Dual(Field, 1), Field) AS Field  Inline
[
Field
A1,
A2,
A3,
A4
];

• ###### Re: customized alighment of the column fields(text) in Pivot table

this gives error-"field name must be unique within the table"

• ###### Re: customized alighment of the column fields(text) in Pivot table

share you expression , will see what s the issue

• ###### Re: customized alighment of the column fields(text) in Pivot table

Hi

If you are using like above, u never got error message.

I think , u are using preceding load with "*".

For test purpose, u simply rename the "new field name " as "Test" and try it out.

• ###### Re: customized alighment of the column fields(text) in Pivot table

As per my knowledge the Individual each values of a dimension not be aligned to different format, we don't have such option in Qlikview.

If a column had text and number values then we can align text in one alignment and number in other alignment.

eg:

[col1

A

B

C

1

2

]

Here we can align A, B, C as using text alignment and 1,2 using numeric alignment but we cannot have different alignment for A and B.

If you want A and B with different alignment then use dual function and attach a number with it

DUAL()