topic Re: Layout Design in QlikView

Layout Design

santharubban — Mon, 24 Nov 2014 22:21:26 GMT

Hi all,

I could like to develop a report in Qlikview as same as
below

Re: Layout Design

MarcoWedel — Mon, 24 Nov 2014 22:46:08 GMT

That's very good news.

Re: Layout Design

santharubban — Mon, 24 Nov 2014 23:40:43 GMT

any idea?

Re: Layout Design

JonnyPoole — Tue, 25 Nov 2014 02:54:02 GMT

From a layout perspective this could be a good use case for NPRINTING reporting addon by VIZUBI.com.

NPRINTING allows you to author reports off QVWs using an excel editor for example. In excel you can author repeating tabular reports with breaks, merges cells, replicate tables within tables etc... for output to excel / PDF and more.

Its not an interactive view however, its strictly for export.

Re: Layout Design

santharubban — Tue, 25 Nov 2014 14:41:57 GMT

Thanks Jonathan... Can you please explain more about your idea, that will help me.

Re: Layout Design

simondachstr — Tue, 25 Nov 2014 14:47:04 GMT

You don't seem to have any aggregations in the report.. Looks like it can be done using rearranged multiboxes/listboxes/textboxes, then play around with the layout settings.

Re: Layout Design

JonnyPoole — Tue, 25 Nov 2014 14:49:04 GMT

Sure. VIZUBI is a 3rd party vendor that develops and licenses a reporting product add-on for QlikView. They are a leader in this area (along with CIA Report Manager) and have many customers.

It is common for QlikView customers to need and support the ability to extract QlikView content into print quality reports and do so in many formats (PDF, XLS, DOC, PPT etc...) .

The product add-on the vizubi creates is called NPRINTING. You can research the solution starting here.

NPrinting - Vizubi: Office and HTML Report Creation and Distribution SoftwareCreate professional Office and HTML reports…

For your needs , the authoring environment in NPRINTING can be based on MS Office templates... and the report layout you posted above matches a grid style layout that would be very easy to do in NPRINTING but hard to do in QlikView. It is for that reason i suggested , although the extra reporting benefits make it a good reason to look at the solution.

You will need a budget to purchase/license NPRINTING as it is not a free solution.

Re: Layout Design

santharubban — Tue, 25 Nov 2014 16:04:26 GMT

Hi Jonathan thanks.. is there anyway without NPrinting.

Re: Layout Design

Tue, 25 Nov 2014 17:46:01 GMT

You may find this helpful

Creating a Report and Using PDF Distribution

Re: Layout Design

JonnyPoole — Tue, 25 Nov 2014 17:51:34 GMT

You totally can, it will just take several objects strategically placed in the layout sheet. See Martin Mahler suggestion below.

Re: Layout Design

ngulliver — Wed, 26 Nov 2014 08:47:31 GMT

Using individual text boxes for each cell is possible but quite time consuming.

Or you can go back to the requester and ask them to justify the cost of developing something like that. If you can display it in a easier format for you, you could save the requester time and money.

Not the answer you probably want to hear but something to consider.

Regards,

Neil