topic Re: Pivot Table in Nprinting. in Qlik NPrinting

Pivot Table in Nprinting.

infosense_devel — Tue, 12 Jul 2016 05:34:41 GMT

Hello,

I have excel template I want to do pivoting for one of my reports I have follow the link below which is suggested by community,

But not get desired output.

I got this from my excel,

And I want something like this,

Here I attached my Template.

Thanks In Advance.

Tue, 12 Jul 2016 07:33:29 GMT

The "level" shouldn't be in the pivot table
Try this tutorial instead. It's a more elegant solution:

How to Create a Pivot Table from Excel Table Columns

Best

Aran

infosense_devel — Tue, 12 Jul 2016 07:58:50 GMT

Thanks @Aran Nathanson for Quick Replay.

Go through your link it will generating same which I have mentioned prior like,

And what I need is Row label Column like Construction , Industrial and Total Group is left to the table like,

Thanks in Advance.

Tue, 12 Jul 2016 08:16:27 GMT

It's an Excel formatting issue.

Go into the design tab in the Excel ribbon and set the formatting the way you want.

If you go into "Report Layout" and select "Tabular format" that should be close to what you want.

However, this is an Excel formatting issue, not an NPrinting/Qlik issue.

Best

Aran

infosense_devel — Tue, 12 Jul 2016 08:47:30 GMT

Thanks Aran.

Really Helpful.

Only one concern I followed your steps and Get output like,

Its as per desired only thing is that I want to remove that Values heading from report only want to display sales and Budget.

tried different option on design tab like Unchecking column header but no luck.

I Have set up like,

Thanks for All.