Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

How to combine the columns

Hello!

I have a graphic as a simple table and it looks like this:

Capturaaaaa.PNG

To gett his result I did this in the script:

DIMENSIONES_CARGABILIDAD:

LOAD * INLINE [

DIM1C, DIM2C, orden_dim1C, orden_dim2C

Hrs.Autorizadas,,0,0

Formación, Hrs.,1,1

Formación, %,1,2

Comunidades,Hrs.,2,1

Comunidades,%,2,2

Total,Hrs.,3,1

Total,%,3,2

No Asignación, Hrs.,4,1

No Asignación, %,4,2

No Reporte, Hrs.,5,1

No Reporte, %,5,2

];

And just print "DIM1C" and "DIM2C" in the graphic dimensions.

The problem is that now I want the first row to be in the middle. The row "Hrs. Autorizadas".

It is in the left since there is a empty space in the dim in the right.

My question is if you know how to combine this row and write that row in the middle of the two columns, not affecting the others rows.

Thanks in advance

1 Solution

Accepted Solutions
Highlighted
Contributor III
Contributor III

Hi,


you can try to put DIM1C = Hrs and DIM2C= Autorizadas.


Qlikview does not allow to combine cells.

fvelascog72‌: You can´t 'play with alignment on diferent cells from the same dimension.

Regards

View solution in original post

3 Replies
Highlighted
MVP & Luminary
MVP & Luminary

I think you need to add the number of spaces which you want to display them differently. For this you could just add them within the value, maybe in this way ... "   Hrs.Autorizadas", .... Another way could be to add the number of spaces as column and then accessing them in an expression like: repeat(" ", SpaceNumber) & DIM1C as DIM1C.  Also possible is to adjust the verbatim-variable to 1 for this load.

- Marcus

Highlighted
Partner
Partner

Hi,

You can use as calculated dimension:

=If(DIM1C = 'Hrs.Autorizadas', '     '&DIM1C, DIM1C)

You can´t 'play' with alignment on diferent cells from the same dimension.

Saludos.

Highlighted
Contributor III
Contributor III

Hi,


you can try to put DIM1C = Hrs and DIM2C= Autorizadas.


Qlikview does not allow to combine cells.

fvelascog72‌: You can´t 'play with alignment on diferent cells from the same dimension.

Regards

View solution in original post