topic NPrinting 17 - cannot expand cycle or level in Qlik NPrinting

NPrinting 17 - cannot expand cycle or level

kdmarkee — Thu, 05 Jul 2018 21:20:48 GMT

NPrinting Publish Task ERROR: Cannot expand cycle or level. Cycle expansion produces an empty filter.

My NPrinting report was running fine but now I am getting this failure message during the Publish Task and just don't see anything wrong with the data, my filters, levels or cycle, my report, etc...nothing pertaining to levels or cycles has changed. Has anyone seen this before and if so, what caused it? Thanks.

Re: NPrinting 17 - cannot expand cycle or level

amehta — Wed, 13 Feb 2019 20:08:47 GMT

I am also facing the same issue. where you able to figure out the reason?

Re: NPrinting 17 - cannot expand cycle or level

kdmarkee — Mon, 08 Apr 2019 20:15:31 GMT

With my original post, I unfortunately do not recall how I got past the error, if I ever did, and I say that because sometimes upgrading NP to a more recent version make issues go away. I did run into this same error today, however, and then re-stumbled upon this post. I can tell you what caused it for me today. For some reason NP did not like that I had a filter set on my user where the choice was "Value is". Once I changed it to "Numeric Value is", the report ran. I'm on Sept 2018 NP and the Log info recorded in the Admin > Task Execution screen was mentioning filter values for the wrong user and that was my first tip that it had to do with a filter. Other things to look for... if using a filter or cycle, I believe there has to be a value that exists for those cycles and filters to work. Look at your QlikView or QlikSense data and mimic what NP is doing with cycles and filters, that may lead you to charts without any rows for those cycle and filter values.

Re: NPrinting 17 - cannot expand cycle or level

Ruggero_Piccoli — Tue, 09 Apr 2019 15:00:11 GMT

Hi,

In the Values drop-down menu you can select from:

Value is: use this option if you want to select a string. For example, if you want to select USA in the Country field.
Numeric value is: in QlikView and Qlik Sense, all field values are potentially dual values. A field value can have both a numeric value and a textual value. For example, a date that could have a numeric value of 40908 and the textual representation "2011-12-31". Use this option if you want to select a numeric value.
Evaluate value: use this option if you want to insert an expression that needs to be evaluated. It must return a single value.

https://help.qlik.com/en-US/nprinting/February2019/Content/NPrinting/ReportsDevelopment/Static-dynamic-filters.htm#anchor-2

The error was generated by an invalid filter selection. Please note that a cycle is a filter.

Best Regards,

Ruggero