Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
Pomna
Creator III
Creator III

NPrinting Pivot Table

Hello I need help with NPrinting pivot table. I need help with NPrinting below is how I want my pivot table to look like 

Pomna_0-1603989528547.png

Below is what I have done so far

Pomna_1-1603989786561.png

Below is  a preview unpivoted.

Pomna_3-1603990284546.png

 

Below is a preview when pivoted. Not exactly what I want.

Pomna_4-1603990371389.png

Any suggestions or links with help on how to fix this will be greatly appreciated. Thanks

 

 

Labels (2)
3 Replies
robert_mika
Master III
Master III

Create a filter in NPrinting and add to the table.

Either by adding only the value you need or by selecting the 'Select excluded' the value you do not want.

I this case your additional line

robert_mika_0-1603991057880.png

(ignore the name of the dimension as it is from a website)

You need to exclude the line that you do not want to show

Pomna
Creator III
Creator III
Author

Thanks for the suggestion but am not trying to exclude any data. I just want my report to look like the pivot table below but am not getting it

Pomna_3-1603996068370.png

 

 

 

Lech_Miszkiewicz
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi @Pomna 

If you want to make your pivot table to look like on your screen why do you put "Position" dimension in your excel pivot table?, To be honest you dont even need pivot table as there is no Pivot dimension (columns) in your Qlik Sense object...

Your requirement isn't really clear to be honest... You may want to prepare mockup in excel of what you are trying to achieve then we may be able to help you more.

cheers

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.