Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Partner
Partner

NPrinting Empty Levels

Hello Everyone,

I am Facing a problem with NPrinting (16 SR3), I am composing an Excel Report with a simple table (eg Customer | Amount )  cycled per Agents level.

Easy so far, my problem is that NPrinting loop and print in Excel ALL the Field Agents (not only the Agents in the source Qlikview Table), even if they are without any customer.

Agent 1

     Customer1 | 5 €

     Customer2 | 2 €    

     Customer3 | 6 €

Agent 2

     Customer4 | 3 €

     Customer5 | 4 €   

Agent 3

Agent 4

     Customer6 | 3 €

     Customer7 | 4 €

Thus I would like to remove all the empty Levels (Agent 3). Any Suggestions?


Thanks a lot

Mirco

1 Solution

Accepted Solutions
Highlighted
Support
Support

Hi Mirco,

You need to create and apply a Field filter with Value something like =Amount > 0. Where you add the filter will make a difference in this case. I suggest using Levels (Agent field) and moving the filter to the Report level.

I have attached a sample project that demonstrates this. Extract to folder C:\Temp\Community\021 or change the paths in the NSQ as required.

HTH - Daniel

View solution in original post

5 Replies
Highlighted
Support
Support

NPrinting cannot exclude a chart if the values are empty for a specific dimension value.

See the following link for more information about this feature request.

not print an empty object in a Report – Customer Feedback for Vizubi

Unfortunately, this is not in the pipeline for introduction in the a future release at this time but you may feel free to add your comments and vote for the idea.

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Highlighted
Contributor III
Contributor III

if cycle is used condition can be used with option: chart X has values,  in this case report for specyfic level will not be created.

I'm looking also this option for non cycle reports

Highlighted
Support
Support

Hi Mirco,

You need to create and apply a Field filter with Value something like =Amount > 0. Where you add the filter will make a difference in this case. I suggest using Levels (Agent field) and moving the filter to the Report level.

I have attached a sample project that demonstrates this. Extract to folder C:\Temp\Community\021 or change the paths in the NSQ as required.

HTH - Daniel

View solution in original post

Highlighted
Support
Support

Very nice solution!

We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!
Highlighted
Creator III
Creator III

Hi, how make it if i use qlik sense? How to move empty levels in nprinting?