topic Re: don't show empty chart Nprinting in Qlik NPrinting

don't show empty chart Nprinting

c_pannese — Fri, 15 Nov 2024 22:41:17 GMT

Hi all,

is there a way to not show empty chart on Nprinting?

thanks

Re: don't show empty chart Nprinting

Lech_Miszkiewicz — Tue, 27 Jul 2021 11:44:32 GMT

Yes there may be a way.
but without details on what you are trying to do (step by step scenario to replicate your requirements including versions of software, type of chart, template, output format etc…) there is no point to guess.
depending on the requirements there may be a solution or may be not…

so please tell us all details about the scenario we need to consider then we can try to work around it.
cheers

Re: don't show empty chart Nprinting

c_pannese — Tue, 27 Jul 2021 12:15:26 GMT

i'm in a cyclic level and i've to show ten different chart,created on pixel perfect directly, based on the dimension Famiglia:5 with monthly information and 5 with cumulative sum of them.

if i try to use a linear table containig all possible value of Famiglia ,creating a sub level Famiglia, the charts are always empty. I've tried to change format of numbers without results.

the only way i found to show chart is creating a table for every value of Famiglia ( 5 tables with linear sum an culuative) and use them in a higer level (Struttura oragnazzativa in the image)

when i generate the report using on demand button , selecting only one or two values of Famiglia, obviusly some chart become empty and i should remove them.

Using the flag "Print when data source in empty" the char never apper, also if there ara data in linear table.

i'm using Nprinting Fabruary 2021.

Thank you very much

Re: don't show empty chart Nprinting

Frank_S — Tue, 27 Jul 2021 17:01:06 GMT

@c_pannese

PxP reports have the ability to show/hide charts.

Please check the steps in this link to proceed to your requirement.

https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/PixelPerfectReports/Manage-Conditional.htm

Re: don't show empty chart Nprinting

Ruggero_Piccoli — Wed, 28 Jul 2021 10:09:45 GMT

Hi,

I agree with @Frank_S , using formatting rules could be a solution.

You could also evaluate to create a straight table, in the connected app, with only the rows for which you want to see the chart. Then you have to refresh the connection cache, close and reopen the Designer and use the new straight table to create the details band. With this solution you will have a band for each row of the new straight table instead of having a band for each distinct value of a field.

Best Regards,

Ruggero

Re: don't show empty chart Nprinting

c_pannese — Thu, 29 Jul 2021 11:04:21 GMT

in my case this was the correct way but i will consider the formatting rule in the feature.

i changed the dimension Anno in my straight table using "=" before the field's name.

thank you all