Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

micheledenardi
Valued Contributor

Hide empty/zeros details on qlik nprinting pixel perfect table

Hi everyone,

i have a nprinting november 2018 pixel perfect report where i would like to hide empty details for a table.

The levels structure is this:

2019-01-18 12_27_54-C__Users_denardm1_AppData_Local_Temp_b995a9fbd5214a678d0334214be4d192_b995a9fbd5.png

i would like to hide details if every column in the final table is =0.

2019-01-18 12_30_01-Report_ SSVI Sales Agent Report.pdf - Adobe Acrobat Reader DC.png

I've already tried below solutions on this discussion https://community.qlik.com/t5/Qlik-NPrinting-Discussions/Empty-levels-in-pixel-perfect-report/td-p/1... it's not working in my case.

Any idea ?

How to hide zeros rows ?

 

Tags (1)
Labels (1)
1 Solution

Accepted Solutions
micheledenardi
Valued Contributor

Re: Hide empty/zeros details on qlik nprinting pixel perfect table

Ruggero,

with your support i found why i didn't see my qliksense straight table on nprinting.

By reading this thread https://qliktech.hosted.jivesoftware.com/thread/308520 you wrote:

2019-01-18 18_11_09-Qlik Nprinting Levels _ Qlik Community.png

So by checking my qliksense straight table i saw that the dimension was calculated:

2019-01-18 18_13_13-NPrinting - Profitability(1) - SSVI Sales Report _ Fogli - Qlik Sense.png

Then, by changing it as below:

2019-01-18 18_14_08-NPrinting - Profitability(1) - SSVI Sales Report _ Fogli - Qlik Sense.png

By refreshing the npriting metadata i found it in the level node list.
2019-01-18 18_14_52-Seleziona Levels.png

Great !!!!

Where did you found the "general rules" ? are there some books/guide ?

View solution in original post

4 Replies
Employee
Employee

Re: Hide empty/zeros details on qlik nprinting pixel perfect table

Hi,

You need to create a formatting rule that made the entity not visible and apply it to the band or to the cells, depending on the result you want.

Condition Editor.pngBest Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.
micheledenardi
Valued Contributor

Re: Hide empty/zeros details on qlik nprinting pixel perfect table

Thanks for yuor reply.

From your screeshot i see that you setup the conditions usign [DBUzjm] field from "Sales Vs Margin" level. I suppose this level is a Qlik straight table object, right ?

The problem is that i cannot include object (O\*) on "level" node,  if i try to add a new level a see only fields (F\*), and not object. Why ? Have I to do something in order to add object in the level node ? The object i would like to add is a  Qlik Sense November 2018 straight table.

2019-01-18 17_39_59-Seleziona Levels.png

micheledenardi
Valued Contributor

Re: Hide empty/zeros details on qlik nprinting pixel perfect table

Ruggero,

with your support i found why i didn't see my qliksense straight table on nprinting.

By reading this thread https://qliktech.hosted.jivesoftware.com/thread/308520 you wrote:

2019-01-18 18_11_09-Qlik Nprinting Levels _ Qlik Community.png

So by checking my qliksense straight table i saw that the dimension was calculated:

2019-01-18 18_13_13-NPrinting - Profitability(1) - SSVI Sales Report _ Fogli - Qlik Sense.png

Then, by changing it as below:

2019-01-18 18_14_08-NPrinting - Profitability(1) - SSVI Sales Report _ Fogli - Qlik Sense.png

By refreshing the npriting metadata i found it in the level node list.
2019-01-18 18_14_52-Seleziona Levels.png

Great !!!!

Where did you found the "general rules" ? are there some books/guide ?

View solution in original post

Employee
Employee

Re: Hide empty/zeros details on qlik nprinting pixel perfect table

Hi,

 

I wrote the rules after a conversation with developers. I also created an improvement for the writers to include them in the official help site.

 

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.