topic Re: Setting chart-based conditions with empty table in Qlik NPrinting

Setting chart-based conditions with empty table

Sebastian_Dec — Tue, 10 Dec 2024 15:19:40 GMT

Hi, I want to set chart-based conditions to Qlik Nprinting (May 2021 SR2 Version: 21.14.5.0).
The report is still being sent with empty results, I don't know what I'm doing wrong, maybe someone can point me to the error.
I read: https://help.qlik.com/en-US/nprinting/June2019/Content/NPrinting/ReportsDevelopment/Conditions.htm but It's possible that I didn't understand something.

I want to make a report showing deficiencies for the dictionary-key -> but if there are no results as in this example then it should not be raported.

I have table in Qlik Sense:
(in my opinion there in no value in table in week 49)

I set conditions in Nprinting:

Object ID for table is 02694a79-86f9-4d44-a2c2-b3282aa5e752
Nprinting allows you to select a table, so I believe that table is a chart.

Unfortunately, the report comes with an empty table, even though the conditions are not met:

If I remove the filter for weeks and there are values in the table, I will also get data:

Conditions in the report:

How can I make the table completely empty?
There is no data in the table only because of the measure, if I delete it the data will appear

Sum({<ERROR={'0'}, KEY={'0'}>} [Sells])

For example, is it better to make a completely new table with empty values by Resident and base the data in the table on it?

Re: Setting chart-based conditions with empty table

David_Friend — Tue, 10 Dec 2024 15:52:14 GMT

What do you have set in the report?

Re: Setting chart-based conditions with empty table

Lech_Miszkiewicz — Tue, 10 Dec 2024 22:25:07 GMT

Hi @Sebastian_Dec

There are 2 obvious things:

you are not setting condition on the report!!! Based on your screenshot you are setting it on TASK which means that any report, user or object filters are not applied at the time when condition is evaluated. Condition set on the report should be done here:
Second thing is that you probably still have 0 values shown! You have to disable it there in the chart ljust like below:

Once you confirm that both things are done let us know how you go.

Cheers.

Re: Setting chart-based conditions with empty table

Sebastian_Dec — Wed, 11 Dec 2024 12:50:26 GMT

@David_Friend , thanks for the answer, I have it set the other way in case of an error it should not generate a report.

@Lech_Miszkiewicz thanks, your answer helped a lot.
I corrected the condition in the report (and task).
I removed Include zero values in Data handling, and I added a filtr for flag/variable that shows errors//nulls that I know are there in data.

Report now works correctly, if there are new "errors" it is sent, if there are no new errors it is not sent:

Re: Setting chart-based conditions with empty table

Lech_Miszkiewicz — Wed, 11 Dec 2024 13:05:42 GMT

Hi @Sebastian_Dec

So in your case which one was it?

0 values or do you also have report/user filters hence condition had to be setup on report and not on task?

Task condition may still be correct place as long as you are validating if whole task needs to run at all. In such case all filters taken into account would be on task level only.

cheers

Re: Setting chart-based conditions with empty table

Sebastian_Dec — Wed, 11 Dec 2024 14:42:27 GMT

0 values in Data handling made the report work properly.

Logs from Qlik Nprinting with only 0 values in Data handling and filtered data from the previous week (where there are no errors)

I added a filter for the user in Qlik Sense, and for myself in Qlik Nprinting "just in case" -> I understand that it is unnecessary and for Nprinting