topic Re: NPrinting Pivot Table in Qlik NPrinting

NPrinting Pivot Table

Pomna — Thu, 29 Oct 2020 16:54:44 GMT

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

Below is what I have done so far

Below is a preview unpivoted.

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

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

Re: NPrinting Pivot Table

robert_mika — Thu, 29 Oct 2020 17:06:30 GMT

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

(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

Re: NPrinting Pivot Table

Pomna — Thu, 29 Oct 2020 18:28:15 GMT

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

Re: NPrinting Pivot Table

Lech_Miszkiewicz — Sun, 01 Nov 2020 23:57:54 GMT

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