topic Re: Border of cells in straight table in QlikView

Border of cells in straight table

Markus_QV — Wed, 24 Jun 2015 08:58:23 GMT

Hi,

I have a question and hope that you can help me.

I need to set a border line between two expression (price and availability).

As you can see you can set all vertical border lines between ALL expressions.

The horizontal border lines you can also change in the cell format screen for each expression or dimension.

But I need this (the red line):

(No Border line between Availability and Av. %)

Hope you can help me.

Best regards

Re: Border of cells in straight table

buzzy996 — Wed, 24 Jun 2015 09:03:20 GMT

right now both(price and availability) are in same expression? if yes..why can't try to create two different expression to get expected result!

Re: Border of cells in straight table

Markus_QV — Wed, 24 Jun 2015 09:09:20 GMT

No, Name is a dimension and price, availability and av. % are separate expressions...

Re: Border of cells in straight table

buzzy996 — Wed, 24 Jun 2015 09:12:32 GMT

if both are different expression,by default u suppose to get that line automatically!

can u share ur app,if possible?

Re: Border of cells in straight table

Markus_QV — Wed, 24 Jun 2015 09:16:48 GMT

attached the qvw.

Re: Border of cells in straight table

buzzy996 — Wed, 24 Jun 2015 09:30:45 GMT

PFA,Use the below one.

Re: Border of cells in straight table

awhitfield — Wed, 24 Jun 2015 09:35:03 GMT

Hi Markus,

enable Vertical Expression Cell Borders:

On the Style Tab

HTH - Andy

Re: Border of cells in straight table

Anonymous — Wed, 24 Jun 2015 09:36:22 GMT

maybe a Workaround which might be okay

you may add a new Expression (e.g. value 1) and use minichart with bars

you can define the background Color as you like

-> BUT: the column is wider than a normal line, maybe there is a way to make the bars smaller, but ididnot achieve it

Re: Border of cells in straight table

Markus_QV — Wed, 24 Jun 2015 09:36:59 GMT

Sorry, that's not what I need.

You just checked in the properties to set all vertical border lines between ALL expressions.

But the problem is I do not want to have a border line between all expressions. Only between price and availability (but not between availability and av. %).

Re: Border of cells in straight table

Markus_QV — Wed, 24 Jun 2015 09:39:51 GMT

Sorry, that's not what I need.

The problem is I do not want to have a border line between all expressions.

Only between price and availability (but not between availability and av. %).

Re: Border of cells in straight table

awhitfield — Wed, 24 Jun 2015 09:45:19 GMT

Hi Markus,

you could cheat and create a dummy expression after price with a value of '|', which would give you:

HTH - Andy

Re: Border of cells in straight table

Markus_QV — Wed, 24 Jun 2015 10:00:46 GMT

Hi Andrew,

yes, that's what I already got in my mind, but I hoped that Qlikview got some "hidden" checkbox/feature to set the style of the borders in a clean way (like Excel etc.) so that I don't need to make that workaround with a dummy expression.

Thanks.