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

[gizzel123]

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.

Thanks in advance

[robert_mika]

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?

[avinashelite]

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 

[gizzel123]

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.

[gizzel123]

Hi

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

how do we do that??

[MayilVahanan]

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
];

[avinashelite]

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:

load * inline

[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()

[gizzel123]

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

[avinashelite]

share you expression , will see what s the issue

[MayilVahanan]

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.