Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

cancel
Showing results for 
Search instead for 
Did you mean: 
infosense_devel
Creator II
Creator II

Pivot Table in Nprinting.

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,

How to Create an Excel PivotTable Report.

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.

4 Replies
Not applicable

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

    How to Create a Pivot Table from Excel Table Columns

Best

Aran

infosense_devel
Creator II
Creator II
Author

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.

Not applicable

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
Creator II
Creator II
Author

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.