topic Re: Border in Straight Table Field in QlikView

Border in Straight Table Field

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Border in Straight Table Field

Frank_Hartmann — Mon, 13 Mar 2017 16:08:31 GMT

i guess this is not possible.

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

hope this helps

Re: Border in Straight Table Field

devarasu07 — Mon, 13 Mar 2017 16:11:57 GMT

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

Re: Border in Straight Table Field

mhmmd_srf — Mon, 13 Mar 2017 16:57:37 GMT

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

How to get this?

Thanks,

Sarif

Re: Border in Straight Table Field

Frank_Hartmann — Mon, 13 Mar 2017 17:00:02 GMT

Yes, because he uses pivot table.

with straight table only horizontal line possible

Re: Border in Straight Table Field

mhmmd_srf — Tue, 14 Mar 2017 16:49:13 GMT

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

Re: Border in Straight Table Field

Frank_Hartmann — Tue, 14 Mar 2017 17:41:30 GMT

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...

Re: Border in Straight Table Field

mhmmd_srf — Wed, 15 Mar 2017 03:33:35 GMT

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

Re: Border in Straight Table Field

devarasu07 — Wed, 15 Mar 2017 07:32:40 GMT

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

Re: Border in Straight Table Field

Frank_Hartmann — Wed, 15 Mar 2017 07:59:32 GMT

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!