how to deal with in invalid selection in levels

[MartW]

I got an report that is using levels to loop over an Qlik table.

the Qlik table in Nprinting also have filters attached.

due to a change request from the customer I changed the filter of the Qlik table a bit.

if I run this outside of the level it runs oke. When I run the report and the Qlik-table is within the level it errors.

I traced the error and can reproduces this In Qlik as well, so I understand why it happens. Nprinting cannot create the table in 1 of the loop operation because 1 out of the 6 values from the level field does produce an invalid selection.

I was wondering if there is a way to disable the invalid selection error Nprinting throws so that the report still keeps running.

NOTE: 

The error handeling is set to Generate report. Invalid content will be replaced with placeholder images.

[Lech_Miszkiewicz]

HI @MartW 

I didnt see your report so I cannot comment on this but there are 2 things you can do:

1. Ensure you always have required combinations of filters/levels by concatenating to data model of your Qlik Sense app required combinations - I know-it is not elegant but works

2. Depending on how your template is constructed maybe you could use advanced search filter which can be semi-dynamic as it can consider current selection state allowing you maybe to either remove not supported (creating problems) level values.

It is very specific to design problem and it needs to be investigated by looking at all elements in your report template including looking at your Qlik data model. 

Bottom line is - there is possible solution, but it may require some Qlik Sense modelling or creative template and filters building.

cheers

[MartW · Accepted solution]

@Lech_Miszkiewicz thx for the response:

"Bottom line is - there is possible solution, but it may require some Qlik Sense modelling or creative template and filters building"

I found my solution. like you mentioned there is a solution, I created a new table that has set analysis baked into the measures of the table. the filters specific for the qlik object is now 1 set analysis statement. Therefore Nprinting will loop over the table with applying the dimension value from the level. then Qlik and Nprinting are forced to give back an empty table as result for values in the level that create an invalid selection.