topic Re: Empty levels in pixel perfect report in Qlik NPrinting

Empty levels in pixel perfect report

woutermak — Mon, 15 May 2017 12:37:36 GMT

Hi,

I have created a pixel prefect report.
I use several levels. Sometimes all levels are used. Some times just the first two of three levels are used. The problem is now that my empty levels are shown as empty records. How can I filter that those levels are not used when there is no data for this level?

The result:

Level 5 and six are empty.

Regards,
Wouter

Re: Empty levels in pixel perfect report

Anil_Babu_Samineni — Mon, 15 May 2017 16:47:17 GMT

Could be you forget to delete extra boxes in Nprinting? Can you check the same

Re: Empty levels in pixel perfect report

woutermak — Mon, 15 May 2017 19:29:18 GMT

Unfortunately not. When I set my last level to hide, the last empty row is disappeared. I have to do something with a check if the level is empty or not.

Re: Empty levels in pixel perfect report

Lech_Miszkiewicz — Tue, 16 May 2017 00:19:18 GMT

Hi,

Maybe try to Edit LEVEL Properties -> Data->Filter String -> ADD (try here to add some kind of filtering like: " Is not null " or something - ()look at second screenshot)

I am not familiar with Pixel Perfect properties as there was never a proper help document created for i - so this is just a pure guess

Re: Empty levels in pixel perfect report

woutermak — Wed, 17 May 2017 13:33:58 GMT

Thanks Lech. It doesn't work for me. I have a working solution.

1. Select the report bound level you want to remove if there is no data

2. Set Visible to No

3. Press on the error

4. Click on the formatting Rules and create a new Rule.

5. Create your condition.

6. Set visible to Yes. You want to display the level when there is some data. This overrules the visible = no in the previous setting (step 2)

7. Link it tho the correct data member (same as in step 1.)

Click close and press on the arrow to apply your rule to the control.

Regards,

Wouter