In short:
On script side i would create a composite key, build of component you are looping your report through (in NPrinting Levels or Pages), then on script i would calculate aggregates for each key (agrregate would be a measure you have in your charts in NPrinitng.
Then - also in script i would calculate flag for each of these keys;
like:
If(aggregate > 0 ,1,0) as myFlag
then in NPrinting i would use myFlag = 1 as a filer on report! Then all combinations with no measure (empty charts) will not be created at all!
The problem is - that it may require a significant change on your datamodel, especialy if your measures components are coming from many tables. That is why without seeing your app it is imposible to tell you exactly how the solution has to look like.
cheers
Lech
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
