Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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>
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?
Three cases within QlikView the export to excel done correctly and order is maintained.
The problem is Nprinting, Thanks for your response.
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?
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>