topic Re: Is it possible to highlight the border of cell in strigh table ? in QlikView

Is it possible to highlight the border of cell in strigh table ?

svsudhakar — Tue, 22 Dec 2015 06:56:21 GMT

Hi ,

I have a straight table like below

Sno	Name	Week-1	Week-2	Week-3	Week-4
1	AA	10	25	33	23
2	BB	20	30	44	24

here I want to highlight the current week column with Thick border or different border color. Kindly suggest how to achieve this.

Regards,

Re: Is it possible to highlight the border of cell in strigh table ?

Tue, 22 Dec 2015 06:58:38 GMT

you can try custom format cell....option border before and after cell

Re: Is it possible to highlight the border of cell in strigh table ?

Chanty4u — Tue, 22 Dec 2015 06:59:51 GMT

hi,

https://community.qlik.com/message/805166#805166

Cell borders on Pivot table

hope this helps u

Thanks

Re: Is it possible to highlight the border of cell in strigh table ?

svsudhakar — Tue, 22 Dec 2015 07:01:01 GMT

Thanks for your reply .

I want to highlight only the current week in that list. How it will change dynamically .

Re: Is it possible to highlight the border of cell in strigh table ?

amit_saini — Tue, 22 Dec 2015 07:02:49 GMT

Hi,

You can try something below in Background color:

if(Week=Week,lightblue(),lightgray())

Thanks,

Re: Is it possible to highlight the border of cell in strigh table ?

svsudhakar — Tue, 22 Dec 2015 07:06:30 GMT

Hi Amit,

I want to change only Boarder not the background color of cell. Because already we used different color codes in that background .

here my requirement is I want to highlight (change the border) for the current week(based on today's date) .

Re: Is it possible to highlight the border of cell in strigh table ?

amit_saini — Tue, 22 Dec 2015 07:14:08 GMT

Hi,

I have suggested different approach , was not aware that you are already using it.

I believe cell border settings just based on current year or week is not possible.

Let's wait for other suggestions.

Thanks,

Re: Is it possible to highlight the border of cell in strigh table ?

jagan — Tue, 22 Dec 2015 07:25:10 GMT

Hi Sudhakar,

It is not possible to assign styles to particular cells, instead you can highlight them with different background color.

REgards,

Jagan.

Re: Is it possible to highlight the border of cell in strigh table ?

ramasaisaksoft — Tue, 22 Dec 2015 07:31:17 GMT

Hi Sudhakar,

For getting Custom Format cell you need to do select option

Settings->User preferences->Design -> Always Show Design Menu items.

after that right click on table 6th option shows "Custom Format Cell"