topic Re: Line seperator in QlikView

Line seperator

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

Hi,

We need to insert an line between my YOY comparative analysis to differentiate .We have used single logic.

Below is the image for reference which we required exactly.

Thanks..

Re: Line seperator

Frank_Hartmann — Fri, 30 Sep 2016 09:11:41 GMT

As far as I know there is no inbuilt feature availible to change this in the properties.

I suppose you will have to create a vertical lineobject and place it on toplayer to the correct position.

Hope that helps!

Re: Line seperator

avinashelite — Fri, 30 Sep 2016 09:18:51 GMT

Did you tried with the Border option in the Layout option ??

Re: Line seperator

awhitfield — Fri, 30 Sep 2016 09:32:51 GMT

You could add a vertical line object, BUT it would be a fixed length

Andy

Re: Line seperator

nareshthavidishetty — Fri, 30 Sep 2016 09:35:10 GMT

Hi,

It's an multi page PDF report,it's not possible to place an line object on top of the chart.

Thanks..

Re: Line seperator

sorrakis01 — Fri, 30 Sep 2016 09:40:03 GMT

Hi,

Maybe you can create different objects (in a no visible sheet) and insert a line Text object.

Regards

Re: Line seperator

Anonymous — Fri, 30 Sep 2016 09:55:14 GMT

Hi,

Try to modify custom format cell, this option is with right button of mouse when Layout Grid is activated.

Regards!!

Re: Line seperator

parevrac — Fri, 30 Sep 2016 10:22:49 GMT

its a bit clunky but I have done this by adding a new field expression into the chart which has no content ( enter '' as the expression) then use the format background for this expression to set the colour and then minimise the size of the column in the table - only works with Straight Tables

Re: Line seperator

awhitfield — Fri, 30 Sep 2016 10:26:44 GMT

You can only alter 'Border before Cell' or 'After Cell' not left or right.

Andy

Re: Line seperator

Frank_Hartmann — Fri, 30 Sep 2016 10:34:18 GMT

if you do it with a pivotable it will work to place the Border left or right!

Re: Line seperator

nareshthavidishetty — Fri, 30 Sep 2016 11:22:56 GMT

Hi,

Please let me know in detail.

Thanks..

Re: Line seperator

Anonymous — Fri, 30 Sep 2016 11:31:18 GMT

Follow this:

1.- Show grid:

2.- Custom cell format on object:

3.- Select on window the cell:

4.- Set Border:

Set apply and Ok, hide grid.

Regards!

Re: Line seperator

nareshthavidishetty — Fri, 30 Sep 2016 12:27:36 GMT

Hi,

It will applicable for all,i required only after some specified columns.

Thanks..

Re: Line seperator

Frank_Hartmann — Fri, 30 Sep 2016 12:47:36 GMT

can you share a sample including this specific table (e.g. with randomized data) ??

Re: Line seperator

nareshthavidishetty — Fri, 30 Sep 2016 18:59:33 GMT

Hi,

It's an pivot table and logic is created with in a single expression for comparative analysis for 2016 and 2015 sales.

Here i need an dark or colored line(Vertical) between 2016 and 2015 sales.

Thanks..