topic Re: Highlight lines in QlikView

Highlight lines

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

Hi,

We have a table which contains few different categories.

The user needs to highlight the boarder lines of the categories by little bit darker compared to other lines.

Please let me know how to get this.

Below is the reference image of the requirement.

Thanks..

Re: Highlight lines

vinieme12 — Wed, 14 Dec 2016 19:44:17 GMT

add a blank expression and fill it's background

Re: Highlight lines

vinieme12 — Wed, 14 Dec 2016 19:46:04 GMT

or add a shade of gray or any other color (I prefer gray!) to your existing expressions that you want to look cut out from the rest

Re: Highlight lines

sergio0592 — Wed, 14 Dec 2016 20:01:30 GMT

The problem is that we can't reduce the column width beyond a certain value. So the line remains too large.

Re: Highlight lines

vinieme12 — Wed, 14 Dec 2016 20:07:37 GMT

yep i know , thats y i always stick to shading existing expressions n that looks better too

Re: Highlight lines

sergio0592 — Wed, 14 Dec 2016 20:18:09 GMT

Ok, but when you say "shading of grey" it's the background color of your expression?

Re: Highlight lines

vinieme12 — Wed, 14 Dec 2016 20:19:38 GMT

Yes, Exactly

Re: Highlight lines

nareshthavidishetty — Wed, 14 Dec 2016 20:23:56 GMT

Hi,

I have created flags.

The logic is sum(sales)

The requirement is to dark the vertical lines.

Thanks..

Re: Highlight lines

sergio0592 — Wed, 14 Dec 2016 20:26:10 GMT

I often do that but the problem is all the cell is colored, not just the border...

Re: Highlight lines

vinieme12 — Wed, 14 Dec 2016 20:29:04 GMT

You cannot do that

Re: Highlight lines

vinieme12 — Wed, 14 Dec 2016 20:31:04 GMT

Yes, but the goal of having borders is to separate out some expressions from the rest and highlighting them also achieves the same

Re: Highlight lines

sergio0592 — Wed, 14 Dec 2016 20:35:14 GMT

I'am 100% agree with you but sometines users don't understand with you can't make a separation border!

Re: Highlight lines

vinieme12 — Wed, 14 Dec 2016 20:42:07 GMT

lol I know

Re: Highlight lines

hectorvega — Thu, 15 Dec 2016 01:17:43 GMT

You have the option to use CUSTOM FORMAT CEL, this option will be shown only when in designer you have the DESIGN GRID enabled and with the right click on the mouse selecting one cell you could reformat the view.

Play with this and you could solve it.

I hope this could help you.

Re: Highlight lines

devarasu07 — Thu, 15 Dec 2016 01:36:59 GMT

Hi,

Sample attached,

Re: Highlight lines

hectorvega — Thu, 15 Dec 2016 01:47:27 GMT

Is it done?