topic Re: How to create Border like excel in QlikView

How to create Border like excel

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

Hi All,

i am facing issue with borders pls let me know if you have any idea to resolve simple way pls find below example

Thanks,

Re: How to create Border like excel

squeakie_pig — Thu, 04 Aug 2016 08:33:01 GMT

What are you trying to add a border to? For most objects there are border settings on the layout tab > Borders.

If you can't see it you may be in simplified mode. Go to settings menu > Document properties > change styling mode from simplified to advanced.

Re: How to create Border like excel

Frank_Hartmann — Thu, 04 Aug 2016 09:05:12 GMT

have a look at this option: Custom Format Cell

hope this helps

Re: How to create Border like excel

susovan — Thu, 04 Aug 2016 09:12:45 GMT

Hi vinod,

You can change the border of chart as you want by this below process.

Re: How to create Border like excel

vinod2086 — Thu, 04 Aug 2016 09:17:55 GMT

Hi Ghoush where is this option is available

Re: How to create Border like excel

Frank_Hartmann — Thu, 04 Aug 2016 09:20:49 GMT

right mouse click into the cell and then follow my picture

Re: How to create Border like excel

vinod_nallapaneni — Thu, 04 Aug 2016 09:30:51 GMT

Enable grid style on design tab. Then right click on chart. you will find the custom format cell over there.

Re: How to create Border like excel

MindaugasBacius — Thu, 04 Aug 2016 09:33:11 GMT

Do like following:

Only then it would be possible to see Custom Format Cell:

Re: How to create Border like excel

Frank_Hartmann — Thu, 04 Aug 2016 09:35:45 GMT

Are you sure?

For me the CustomCellFormat Option even works when grid view is unselected!

Re: How to create Border like excel

MindaugasBacius — Thu, 04 Aug 2016 09:40:14 GMT

Well for me it do not work that way:

Re: How to create Border like excel

susovan — Thu, 04 Aug 2016 09:40:35 GMT

First of all on the design grid view option under view menu,

then right click on the chart which you want to change the border style then click on custom format cell

Re: How to create Border like excel

vinod_nallapaneni — Thu, 04 Aug 2016 09:42:04 GMT

Re: How to create Border like excel

Thu, 04 Aug 2016 09:42:07 GMT

Hi Vinod,

We can, you can take line object and do has horizontal and vertical as well your req and also need any advance settings ---> Go to settings --> Document properties --> change style mode -> simplified <--> advanced.

Thanks

Nandu

Re: How to create Border like excel

Frank_Hartmann — Thu, 04 Aug 2016 09:47:17 GMT

thats really strange. i use the same version: