When creating a “Qilkview Entity Report”, if the object you want to add contains a “cyclic group”, the generated report will be based on a default field i.e. the last selected/saved field in “cyclic group”.Issue:
For “Qilkview Entity Report, if you want to generate a report based on a specific field within a cyclic group, you need first to select a field from a list in “cyclic group”, save Qilkview application before launching the task that will generate the report. A workaround is to use cyclic group which displays a dimension based on the values of a QlikView variable
For all other report types i.e. Ms Word, MS Excel, PowerPoint and /or HTML Reports , if there is a cyclic group, it’s possible to specify the dimension to use (field included in the “cyclic group”) or set the dimension to the “active field” active field at the time the report is generated. See How to Manage Dimensions Containing Cyclic Groups in NPrinting reports
Qilkview Entity Report does not have this future.
You can overcome this by:
a. Creating a chart with a cyclic group which displays a dimension based on the values of a QlikView variable
b. Create an NPrinting filter which sets the value of that variable
c. Add the Filter to the Report for that chart
d. This will force the variable to a specific value which will in turn set the cyclic group to the desired dimension.