Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
quiquegzz
Partner - Contributor III
Partner - Contributor III

Hidden Pivot Table Field Nprinting (Nprinting Campo Oculto Tabla Pivote)

How are you.

Nprinting generate report in excel.

These are the values ​​to display and order.

Description OrderID Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD

1 Floors 100 200 300 0 0 0 0 0 0 0 0 0 600

2 Corporate 150 100 50 0 0 0 0 0 0 0 0 0 300

3 foreign 100 100 150 0 0 0 0 0 0 0 0 0 450

in the pivot table in QV not show the OrderID, but the arrangement is applied to the Description.

Description Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD

Plants 100 200 300 0 0 0 0 0 0 0 0 0 600

Corporate 150 100 50 0 0 0 0 0 0 0 0 0 300

Foreign 100 100 150 0 0 0 0 0 0 0 0 0 450

in QV if the order is maintained, but Nprinting not respect this order and put it this way.

Description Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec YTD

Corporate 150 100 50 0 0 0 0 0 0 0 0 0 300

Foreign 100 100 150 0 0 0 0 0 0 0 0 0 450

Plants 100 200 300 0 0 0 0 0 0 0 0 0 600

I can support for the respect ?? order.

I also attach proof of the OrderID field in the table and gave the property does not show,

but Nprinting this field is not added to include objects within table property.

Annex picture.

The detail is here that I can not display the OrderID or the QV report nor in Nprinting.

I thank you in advance for your support.

Translated with Google Translate - Qlik Community Administrative Team

Que tal.

Nprinting generar reporte en excel.

Estos son los valores a mostrar  y el orden.

OrderID  Descripcion Ene Feb Mar Abr May Jun Jul Ago Sep Oct Nov Dic    Acum

1            Plantas        100 200 300  0    0      0    0    0     0     0     0    0       600    

2           Corporativo  150 100  50    0    0      0    0    0     0     0     0    0      300

3           Foraneas      100 100 150  0    0      0    0    0     0     0     0    0      450

en la tabla pivotante en QV no muestro el OrderID, pero en la ordenación se lo aplico al Description.

Description Jan Feb Mar  Abr May Jun Jul Ago Sep Oct Nov Dic   Acum

Plantas        100 200 300 0    0      0    0    0     0     0     0    0       600

Corporativo  150 100  50  0    0      0    0    0     0     0     0    0       300

Foraneas      100 100 150  0    0      0    0    0     0     0     0    0     450

en QV si se mantiene el orden, pero en Nprinting no respeta dicho orden y lo pone de esta forma.

Description Jan Feb Mar  Abr May Jun Jul Ago Sep Oct Nov Dic   Acum

Corporativo  150 100  50  0    0      0    0    0     0     0     0    0       300

Foraneas      100 100 150  0    0      0    0    0     0     0     0    0     450

Plantas        100 200 300 0    0      0    0    0     0     0     0    0       600


Me pueden apoyar para que se respete el orden??.


También hice la prueba de anexar el campo OrderID en la tabla  y le di la propiedad no mostrar,

pero en Nprinting este campo no se agrega al incluir los objetos dentro de propiedad de tabla.

anexo imagen.


El detalle aca es que no puedo mostrar el OrderID ni en la reporte de QV ni tampoco en Nprinting.


Les agradezco de antemano su apoyo.










1 Solution

Accepted Solutions
quiquegzz
Partner - Contributor III
Partner - Contributor III
Author

And I found the problem.

The problem is that field Description was not ordered by the expression

property "OrdenID".

The solution is to use the expression property field to order.

In my case, my mistake was that the OrderID field was within the table was

hidden, and the order was respected.

Thanks Andrea for your time.

2015-07-17 10:06 GMT-05:00 Andrea Ghirardello <qcwebmaster@qlikview.com>:

Qlik Community <https://community.qlik.com/?et=watches.email.thread> Nprinting

Campo Oculto Tabla Pivote

respuesta de Andrea Ghirardello

<https://community.qlik.com/people/ANDREA_GHIRO?et=watches.email.thread>

en QlikView NPrinting - Ver la discusión completa

<https://community.qlik.com/message/824777?et=watches.email.thread#824777>

View solution in original post

4 Replies
Andrea_Ghirardello

Hi,

I think the problem is related on how QlikView exports pivot tables into excel files.

Please try exporting the pivot table from within QlikView manuallly:

- Right click on the pivot, select Export, choose .xls

OR

- Right click on the pivot, send to Excel

OR

- use the "Send to Excel" special Icon

Is it the result the same you see in QlikView?

quiquegzz
Partner - Contributor III
Partner - Contributor III
Author

Three cases within QlikView the export to excel done correctly and order is maintained.

The problem is Nprinting, Thanks for your response.

Andrea_Ghirardello

Looking at the image I realized that you are not exporting a pivot table.

Are you using the Table tag into the template or different single column tags?

quiquegzz
Partner - Contributor III
Partner - Contributor III
Author

And I found the problem.

The problem is that field Description was not ordered by the expression

property "OrdenID".

The solution is to use the expression property field to order.

In my case, my mistake was that the OrderID field was within the table was

hidden, and the order was respected.

Thanks Andrea for your time.

2015-07-17 10:06 GMT-05:00 Andrea Ghirardello <qcwebmaster@qlikview.com>:

Qlik Community <https://community.qlik.com/?et=watches.email.thread> Nprinting

Campo Oculto Tabla Pivote

respuesta de Andrea Ghirardello

<https://community.qlik.com/people/ANDREA_GHIRO?et=watches.email.thread>

en QlikView NPrinting - Ver la discusión completa

<https://community.qlik.com/message/824777?et=watches.email.thread#824777>