topic Re: Vertical cell border in straight table in QlikView

Vertical cell border in straight table

Anonymous — Thu, 30 Jan 2014 13:19:28 GMT

Hello everyone,

Is it possible to change the vertical cell borders in a straight table ?

I already searched in the custom format cell properties and in the table properties, I only found how to change the horizontally cell borders.

I also tried to change the style of the table but it removed my color condition on the dimension header: if(vOption=1, rgb(...), rgb(...))

See the foolowing capture:

Thanks,

Quentin

Re: Vertical cell border in straight table

jvishnuram — Thu, 30 Jan 2014 13:28:27 GMT

Hi Bruno,

I thought that couldn't be possible., if you want you can user the line or arrow object to place over the straight table.

Re: Vertical cell border in straight table

MK_QSL — Thu, 30 Jan 2014 13:31:18 GMT

Go to Settings

Use Preferences

Design

and select Always Show Design Menu Items

Now Right Click on any cell of Straight Table

and select Custom Format Cell

Border Before Cell - Select any border and

below color select Black.

That will solve your problem...

Re: Vertical cell border in straight table

Anonymous — Thu, 30 Jan 2014 13:40:17 GMT

Hi guys,

Thanks for your quick answer.

Manish, I tried your solution but it still doesn't work, I can only change the horizontal color. I want to have grey borders everywhere.

Thanks,

Quentin

Re: Vertical cell border in straight table

MK_QSL — Thu, 30 Jan 2014 13:46:15 GMT

Oh.... It will work on Pivot Table... In Straight table you can change only horizontal lines...

Re: Vertical cell border in straight table

Anonymous — Thu, 30 Jan 2014 13:55:43 GMT

It still doesn't work.

Here is what I get when I convert in a pivot table:

Quentin

Re: Vertical cell border in straight table

Anonymous — Thu, 30 Jan 2014 13:56:55 GMT

You can do something like this by inserting an image...

Re: Vertical cell border in straight table

Anonymous — Thu, 30 Jan 2014 14:09:27 GMT

Hi,

Thanks for your solution but I just want a thin grey border everywhere and not separate columns.

Thanks,

Quentin

Re: Vertical cell border in straight table

MK_QSL — Thu, 30 Jan 2014 15:12:43 GMT

It will work on pivot table....

Re: Vertical cell border in straight table

Mon, 02 Jun 2014 18:37:46 GMT

please read the question he mentioned specifically vertical cell border..this where everybody struggling while generating important report .to get custom format you don't need to do the settings just click on snap grid and right click on table you will get ..if you have any solution for getting the cell borders in pivot table as like exactly in the excel cell please share..struggling a lot

thank you.

Re: Vertical cell border in straight table

Tue, 14 Jul 2015 19:07:10 GMT

Hey man do you have a QVD with this example?

Re: Vertical cell border in straight table

Wed, 30 Sep 2015 12:25:47 GMT

Hi Quentin,

I am not sure if you can adjust the color of it. But you can hide the vertical borders for either your dimensions and/ or your expressions:

Straight table properties, Style:

Unselect 'Vertical Dimension Cell Borders' and

unselect 'Vertical Expression Cell Borders'

Re: Vertical cell border in straight table

Thu, 21 Jul 2016 14:18:22 GMT

Excellent!! It worked! I was going nuts with this haha.

Greetings!

Re: Vertical cell border in straight table

Anonymous — Thu, 21 Jul 2016 16:50:32 GMT

Hi Diego,

We're glad to see you got the solution you were looking for. Please take a moment to mark replies as correct or helpful, in order to give credit to those who helped you and to designate this thread as Answered.

For more information, see Qlik Community Tip: Marking Replies as Correct or Helpful

Thank you,

Qlik Community Team

Re: Vertical cell border in straight table

Thu, 21 Jul 2016 17:08:50 GMT

Hi Jeremy! Thanks for the Tip

But my Action buttons says that there are no actions available, I don't know why.

Re: Vertical cell border in straight table

Anonymous — Thu, 21 Jul 2016 20:34:43 GMT

Hi Diego,

If you are viewing the thread within your Actions & Inbox area of your profile, there are not as many options there. You will need to view the actual thread in the community, rather than your Inbox. Here's a link to the thread: Re: Vertical cell border in straight table

Let me know if you still aren't able to see the Correct Answer buttons and use the Actions menu on the thread within the community.

Re: Vertical cell border in straight table

Thu, 21 Jul 2016 20:37:47 GMT

Jeremy the only action i can make is the Report Abuse one, maybe it's because i'm new here....

Re: Vertical cell border in straight table

Anonymous — Thu, 21 Jul 2016 20:41:58 GMT

Ah, I see what the issue is. Those options are only available to the member who started the thread. Sorry about the confusion!

Re: Vertical cell border in straight table

Thu, 27 Oct 2016 10:10:27 GMT

Hi Quentin ,

Please change the straight table style to basic in the style tab(the vertical lines will come as black) , then apply custom formatting for background color etc . Hope this helps .

Regards,

Shantanu