Border in Straight Table Field

[mhmmd_srf]

Hi All,

I have a straight table like:

I need a Black and Bold border in Left side of Actual and Right side of Plan.

Please help.

Thanks,

Sarif

[Frank_Hartmann]

i guess this is not possible.

but you can place a transparent line object on top of your table:

hope this helps

[devarasu07]

Hi,

By Using Grid mode (Ctrl+G) you can able to do it.

refer to the attached sample (to enable grid mode press Ctrl+G) then custom format cell

Thanks

Deva

[mhmmd_srf]

I am not getting Vertical line... I am getting horizontal line..

How to get this?

Thanks,

Sarif

[Frank_Hartmann · Accepted solution]

Yes, because he uses pivot table.

with straight table only horizontal line possible

[mhmmd_srf]

Hey Frank,

I am able to get border. But I want to get make border left side of Level Actual and right side of Level Plan.

Not only side of value.

How to get this.

Please help.

Thanks,

Sarif

[Frank_Hartmann]

what kind of table are u using? Straight Table or Pivot?

what about devarasu07 ´s solution? that might be the best solution if its possible for you to use pivot table

Can u show a screenshot of what you have and how you did it?

or better upload a small qvw with random data that will be much easier for assisting...

[mhmmd_srf]

Hello Frank sir,

I am using Pivot table. and I am getting out like below:

The border should increase to one level up. Left hand side of the word Actual and right hand side of the word Variance also.

How to make this please help.

Thanks,

Sarif

[devarasu07]

Hi Sarif,

requested format can't be done. because if we apply custom cell border format for column header in pivot it will apply all the columns (there is no specific fields to define).

FYI, u can see below image (there is line in b/w Actual and plan).

i would suggest advise your users there is limitation in qlikview or if you have qlikview Nprint then achieve expected customization.

Hope this helps you

Regards,

Deva

[Frank_Hartmann]

afaik, if using pivot table you can set the grid either to all of the dimensions or to none.

If you need the grid in the dimension the same way like doing in the expression you will have to go with the above mentioned solution to put a small line object on top of the pivot table.

but perhaps someone has a better solution and might correct me!