topic Re: Pixel Perfect - Data not visible in Qlik NPrinting

Pixel Perfect - Data not visible

vitaliichupryna — Mon, 10 Feb 2020 13:17:42 GMT

Hi,

I've created report with few levels, in general it works fine, but I can't fix one bug.

When data in the Measure 1 or 2 is 0 in the Qlik. Nprinting shows empty space instead of data.

I don't understand why it's happened and how to fix it, I tried add text function :text(Sum(Measure1)), but still have the same result

Qlik
Level
SubLevel	Measure1	Measure2	Measure3	Measure4
A	1	1	1	2
B	0	0	3	3
C	0	0	4	6
D	3	1	4	2

Report
Level
SubLevel	Measure1	Measure2	Measure3	Measure4
A	0	0	1	2


D	3	1	4	2

Re: Pixel Perfect - Data not visible

Ruggero_Piccoli — Mon, 10 Feb 2020 13:49:20 GMT

Hi,

Could you post some screenshots of the template? I think you added the wrong entity in the Levels node. You have to add the same straight table used in the level details band. In the entity added in the Levels node those rows are present, but they are not in the entity inserted in the details band.

Another alternative is to apply a formatting rule to hide rows with no data to the detail band.

Best Regards,

Ruggero

Re: Pixel Perfect - Data not visible

vitaliichupryna — Mon, 10 Feb 2020 15:17:33 GMT

Hi Ruggero,

In the qliksense I see data, data isn't visible in the report.

On the top level I use field BDName and then on the second level I use straight table.

I tried to use straight table on the top and second level, but in this case I can't generate report

Re: Pixel Perfect - Data not visible

Ruggero_Piccoli — Mon, 10 Feb 2020 15:53:35 GMT

Hi,

Thanks. In the Detail7 band you inserted the first field Attrition_BUname_1 but it is not visible in the BD/BU table. Where that field come from? Maybe you have to replace it with the Attrition_BUname field that appears in the table.

Best Regards,

Ruggero

Re: Pixel Perfect - Data not visible

vitaliichupryna — Tue, 11 Feb 2020 09:11:57 GMT

Hi,

Attrition_BUName_1 is comming from table tVPFQ - BD/BU for this reason it's not visible in the level.

I changed template and started to use columns from level and it shows all the data. I'm a little bit confused because based on the tutorials we should add table and use table in the Detail part.

Ruggero - thank you for help!

Thanks,

Vitalii

Re: Pixel Perfect - Data not visible

Lech_Miszkiewicz — Tue, 11 Feb 2020 23:44:39 GMT

https://help.qlik.com/en-US/nprinting/November2019/Content/NPrinting/PixelPerfectReports/Simple-PP-Report.htm

Official help tutorial seem to use fields from level. @vitaliichupryna what tutorial are you using?