topic Re: how to have a vertical line in static reports in QlikView

how to have a vertical line in static reports

aniketsr — Sat, 16 Nov 2024 01:47:38 GMT

Hi All,

Iam unable to create a vertical solid line in the static report because the line object is not accepted by the report layout.

i used Repeat('|',14) but i get dotted line but we require solid lines.

any work around or help will be appreciated.

Re: how to have a vertical line in static reports

johnca — Tue, 03 Dec 2019 17:54:39 GMT

What version are you using? On server or Desktop? What object are you using? Have you tried =Repeat('|',14) in a text object and get the same result?

Re: how to have a vertical line in static reports

aniketsr — Tue, 03 Dec 2019 18:02:35 GMT

Hi ,

Iam using QV 12 . Yes i tried using repeat function in text box but i get dashed lines . The expectation is to have a solid line.

Re: how to have a vertical line in static reports

johnca — Tue, 03 Dec 2019 18:29:56 GMT

How about: Repeat(chr(151),14) This create a horizontal line.

Are you looking for a vertical line using pipe? The best I could think of is

=chr(9474) &chr(10)&
chr(9474) &chr(10)&
chr(9474) &chr(10)&
chr(9474) &chr(10)&
chr(9474) ...

but is hardly dynamic and is broken. Maybe someone else knows of a way to make a vertical line dynamic.

Re: how to have a vertical line in static reports

johnca — Tue, 03 Dec 2019 21:52:09 GMT

And I totally missed this one...DOH!

Why not use a Line/Arrow object?

Re: how to have a vertical line in static reports

aniketsr — Wed, 04 Dec 2019 06:02:35 GMT

Line object cannot be dragged in the report designer

Re: how to have a vertical line in static reports

johnca — Wed, 04 Dec 2019 14:52:03 GMT

I'm missing something here.

Do you have the "Allow Move/Size" box on the Layout tab UNchecked? That will stop you from moving it.

Make sure it is checked.

Re: how to have a vertical line in static reports

Brett_Bleess — Wed, 11 Dec 2019 15:40:51 GMT

Did John's last post regarding the Move/Size option get things working for you with the line arrow objects? If so, be sure you return to the thread and use the Accept as Solution button on that post to give him credit for the assistance and to let other Community Members know this worked for your use case. If you still have further questions, leave an update.

Regards,
Brett