Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

berndjaegle
Contributor

Nprinting 17 - show dimension across

Hi guys,

how can I put a dimension across in an Excel template?

It is simple table where I want to show the dimension MONTH in columns.

When I start the report MONTH is shown in rows.

But I need columns.

This is how it is shown in QlikSense.

Nprinting_table_across.jpg

Thanks for you hints.

Best regards,

Bernd

3 Replies
sureshqv
Esteemed Contributor III

Re: Nprinting 17 - show dimension across

is it stright table or pivot?

whatever you can create custom template and you can use the same

devarasu07
Honored Contributor II

Re: Nprinting 17 - show dimension across

Hi,

Try to create levels in your excel template and then u can able to get the desired output. Thanks

How to Create an Excel PivotTable Report

try the same steps in your Nprinting 17 & it should work (my side i've only 16)

Regards,

Deva

ogster1974
Honored Contributor II

Re: Nprinting 17 - show dimension across

You bring your data in a straight table then use that as your source for your piviot you setup in Excel.

You cannot use Piviots from Qlik Sense directly in NPrinting unless as an image.

Regards

Andy

Community Browser