topic Re: Is this possible? in QlikView

Is this possible?

TKendrick20 — Wed, 02 Apr 2014 14:30:25 GMT

Is it possible to format a QlikView sheet so that it is the dimensions of an 8.5 x 11 sheet of paper. Then, I can build a dashboard and export it very cleanly to a pdf? Any information would be appreciated.

Note: I DO NOT want to use the Report Editor because I can't place objects all the way to the edge of the page.

Re: Is this possible?

its_anandrjs — Wed, 02 Apr 2014 14:36:29 GMT

Yes you can design the qlikview worksheet as 8.5 x 11 but suggesting if you use report editor. But you can create a page as this width x height 8.5 x 11.

Hope this helps

Re: Is this possible?

TKendrick20 — Wed, 02 Apr 2014 15:17:38 GMT

I just want to be able to print the QlikView dashboard to a standard Letter-sized pdf. The Report Editor does not do what I need to do.

Re: Is this possible?

its_anandrjs — Wed, 02 Apr 2014 15:19:59 GMT

Oh i dont thing so that will be possible refer the report editing will help you there.

Re: Is this possible?

richard_pearce6 — Wed, 02 Apr 2014 15:39:06 GMT

Hi Tim

I've had a quick look and an option would be to create some lines that mark out the right and bottom areas of the print screen (using print preview to check and adjust)

When I did it the visible areas of the page seemed to be close to perfect although that may be a screen resolution thing.

Regards

Richard

qlikcentral | Understand / Create / Inform

Re: Is this possible?

richard_pearce6 — Wed, 02 Apr 2014 15:56:05 GMT

Hi Tim

I've had a quick look and an option would be to create some lines that mark out the right and bottom areas of the print screen (using print preview to check and adjust)

When I did it the visible areas of the page seemed to be close to perfect although that may be a screen resolution thing.

Regards

Richard

Re: Is this possible?

TKendrick20 — Wed, 02 Apr 2014 16:11:25 GMT

I've been working on a similar approach. I'll upload more information once I work with it a bit more.

Re: Is this possible?

Wed, 02 Apr 2014 16:13:53 GMT

Hi Tim,

You can try using a picture file with your desired size as a background of the sheet. Make sure to select the 'No Stretch' Image formatting. I have attached one you can use. It shows boundary lines for your 8.5x11 size.

Cheers!

Re: Is this possible?

TKendrick20 — Wed, 02 Apr 2014 16:25:03 GMT

This method is ineffective. The screen's resolution formats the print preview differently. Unless you can commit to only printing from one screen, this is not a viable option.

Re: Is this possible?

TKendrick20 — Wed, 02 Apr 2014 16:28:43 GMT

When I go to print, though, QlikView wants to print the sheet with all visible negative space around this background unless I manually resize the window.

Re: Is this possible?

Wed, 02 Apr 2014 16:37:11 GMT

Have you tried zeroing out the Margins in Report Editor? The "0.3" allowances are for the printer..

Reports Editor > Reports > Reports Settings > Margins.

If you want to printout whatever is in your sheet then Report Editor is actually the easiest way to go.

Re: Is this possible?

TKendrick20 — Wed, 02 Apr 2014 16:47:58 GMT

Yeah, I may have to just deal with it and use the report editor. I'll mostly be printing to pdfs. I guess I thought there would be an easier way.

Re: Is this possible?

richard_pearce6 — Wed, 02 Apr 2014 16:49:08 GMT

I think there's an option in the print settings stop that. I'm away from my desk but will have a look tomorrow for you unless you manage to find it

Richard.

Re: Is this possible?

richard_pearce6 — Wed, 02 Apr 2014 17:22:08 GMT

Yes it won't work with multiple sheets.

The report writer is ok. Takes a bit of getting used to although I haven't touched it for a few years.

Hope it goes well

Rich

Re: Is this possible?

TKendrick20 — Wed, 02 Apr 2014 17:58:02 GMT

Well the worst thing is that you can't view extension objects in the report editor.