topic Re: Set cell border on custom cell format in QlikView

Set cell border on custom cell format

NickP_DF — Tue, 09 Feb 2021 18:21:47 GMT

Hi guys,

I'd like to set all the border to my cell table, but the custom format cell doesn't allow it to me; where am I faulting?

Pls have a look to the attached image.

Thanks.

Re: Set cell border on custom cell format

MayilVahanan — Wed, 10 Feb 2021 01:42:41 GMT

Hi @NickP_DF

Try like this

Re: Set cell border on custom cell format

NickP_DF — Wed, 10 Feb 2021 09:09:18 GMT

Thank you for the reply,

I had already tried it before, but it doesn't work

Re: Set cell border on custom cell format

marcus_sommer — Wed, 10 Feb 2021 10:43:50 GMT

There exists a priority between the various formatting settings (custom cell format, attribute expression, settings from the tab visualization + design). Unfortunately I don't remember exactly which one will win if there are different settings set as the default ones - but AFAIK if you had set borders/background to transparent in tab design it will win against the custom cell format.

- Marcus

Re: Set cell border on custom cell format

NickP_DF — Wed, 17 Feb 2021 17:45:06 GMT

Hi Marcus,

sorry for the delay of my answer, but I didn't get the notification of your post.

However, I've found another table in which the all borders were set and I've tried to find the differences between the two tables; since I wasn't able to find them, I've copied and adapted the expression of the second table in the first one, and I solved the problem with this workaround 🙈

Thank you so much for your response. 🙂

Nick.