Thank you for your reply.
The ‘blank’ does not come from the data...it comes from the Nprinting table objects. When you ‘mark’ the data on the named sheet, you need to mark the blank line below the data as well, otherwise you only return one value.
That;s where the blank comes from..
Sorry for the late reply
Please find attached...I am not sure where I should use the delete row in this instance...
I use the table from QV, then I create a pivot Chart re reproduce the format the customer wants.
qq.xlsx 115.4 K
You don't mention NPrinting version nor Qlik source? But I assume NPrinting 17.2.2 and QlikView...
I think you should fix this in the data source - QlikView.
How does i look in QlikView? Like you intend to insert in the template? Then it shoud work.
But I have experienced since NP 17.2.2 that blank (null) values appeared in dimensions. My work-a-round was to go to the source and open Chart Properties box, select the Dimension tab and mark the box for "Suppress When Value Is Null".
That has helped me.
"Delete Row" in the NPrinting template is not a feasible path for this issue in my perspective.
Thanks for your reply
We are still on version 16 Nprinting
Thing is... It's not the dimensions that are null... It gets created when I mark the data in die spreadsheet for a pivot chart
Maybe I have it all wrong. I need to pivot the data in the chart to get the desired result.
Sent from my Samsung Galaxy smartphone.