Table in Nprinting Pixel Perfect showing only first row

[PoojaPrasad]

Hello Team,

I needed help to resolve the issue I am facing on Pixel Perfect table. In qlik sense app, I have created a table that has more than 1 rows for each employees(levels in the report). In Pixel Perfect Report, when I am selecting and dropping that table as full or even column wise, I can only see the first row in the pdf preview. In the property grid of Table cell, I have made Row Span = 5(it can be N numbers but just for testing I have put >1), but still I see only the first row.

I was wondering if you have any idea on how to retrieve all the rows of a table in Pixel Perfect Nprinting report.

Thank you in advance,

[Daniel_Jenkins]

Hi,

https://help.qlik.com/en-US/nprinting/April2019/Content/NPrinting/PixelPerfectReports/Understand-Fea...

"Table

In PixelPerfect templates, tables are data sources for charts and sparklines. If you want to create a table in your report, you must use levels. You do not add the source QlikView table in the Tables node.

To add a table, do the following:

1. Right-click the Tables node, and then select Add objects.
2. Click on the desired object from the list that appears."

I suggest you go through the Qlik YouTube channel series of videos on PixelPerfect

The one that specifically addresses native tables is: https://www.youtube.com/watch?v=z-VprSroEW0&list=PLkRFvjyuHFvIw0RUJmL3l1FmQzjFNHtRS&index=7

HTH - Daniel. 

[PoojaPrasad]

Hello Daniel,

Thank you for the response. I had gone through the link you shared. I tried to follow the steps to add Qlik Sense App table into the pixel perect Nprinting report, but I dont see the table name in the 'add levels' options. I see all the column names/field names only. So, I am not getting the structure of the table as described in the tutorial video. I have attached the Qlik Sense App table layout and Nprinting screenshots for reference.

Qlik Sense App Table layoutTableNameNotShownWhileAddinginLevel

[Frank_S]

If your chart is not visible as a 'level' then there is a good chance you are working with a pivot table. 

In this case, you would need copy your pivot table and convert the copy  to a straight table.

Once finished converting, you need to click 'done' to save your changes in the QVF and then reload the metadata in your NPrinting connection to see the straight table as a level. 

Just a suggestion but it may be useful to get some one to one or classroom training to better leverage NPrinting for your business needs. 

Paid training is available here: https://www.qlik.com/us/services/training/qlik-sense-training or just click https://inter.viewcentral.com/events/cust/search_results.aspx?keyword=&cat1_id=77&postingForm=defaul...

You can also go through all the free Qlik Videos as well but you might get more out of formal training possibly to better server your designing requirements.

https://www.youtube.com/channel/UCFxZPr8pHfZS0n3jxx74rpA/playlists?shelf_id=15&sort=dd&view=50

We also have partners that deliver NPrinting training. If you need more information on those options, please reach out to your Qlik Account or partner manager for details and options therein.

Kind regards...

[PoojaPrasad]

Hello Frank,

Thank you for the information. I would look for these options.

As of now, I dont have any pivot table in the qlik sense app. All of them are tables.  For testing purpose, I created a new table on qlik sense app with the same fields as columns, reloaded metadata in the connection and tried to add that table in label on Nprinting Pixel Perfect editor. But I don't see any object with the table title. The columns are all present as Field type.

[Frank_S]

Understood.

In order to accomplish your objective, you will need to create another straight table but only use your data as dimensions. Do not add measures. You can only use 'Dimensions' in order to process your output as expected. 

In my example I added total sales and gross product as dimensions to my straight table.

Reloaded the NPrinting metadata to this QVF connection and the table now appears in the expected format. 

Preview your report.

Note that in order to get 'currency' or whichever format you need, you should update each cell property and "format string' to accomplish data cell formatting. Again...this requires deeper understanding of the product but if you follow the videos, you may get what you need around formatting. Otherwise I suggest the training path as mentioned earlier.

Hope this helps to guide you in the correct direction.

[PoojaPrasad]

Thank you for an elaborate step wise explanation of the process. Really appreciate it. The strange part is I did exactly the same that you have shown. Took the table chart, added columns as 'dimensions', reloaded the metadata in connection and opened the Nprinting Pixel Perfect Editor by editing the report. Exact same steps, but I dont see the table name as object while adding it in levels. You will notice it in my previous comment with screenshots. I dont understand why I am not able to replicate it.

Worst case, I will create a new connection and new report to see if I am getting the table name as an object while adding it in levels.

Thank you,

[Frank_S]

If you haven't already done so, you should insert a chart name in your app then reload again in NPrinting so it is visible to NPrinting...otherwise only the object ID for the chart will appear (which you can also use). 

[PoojaPrasad]

Yes, I do have the title in the table chart I am trying to print through Nprinting. The issue is that I dont see that object while adding objects to 'Levels' in  Nprinting Pixel Perfect editor.

[Frank_S]

At this point, it would appear that you will be better served by starting a support case with our support desk so that we can look further into this for you in greater detail.