How to iterate fields from different tables at the same time?

artmar — Tue, 14 Jan 2025 14:24:40 GMT

Since, apparently, I can add only one Data Member to each DetailReport to bind the fields and iterate them, I was wondering how to iterate multiple fields from multiple tables even if the Data Member is always the same.

For instance, I want to iterate all my 4 fields at the same time, but since I can add only one table in the Data Member (for example the first column in this case which is Column_Header), it will iterate only that one, being the only binded one.

Moreover, whenever I add each field, Pixel Perfect creates their own levels, I'm not doing that, which is why they're in different tables I guess.

4 fields from 4 different levels

Re: How to iterate fields from different tables at the same time?

Frank_S — Tue, 14 Jan 2025 23:12:03 GMT

If I understand your requirement, it is not possible to used different tables inside a single band.
To do that you would need to create a straight table inside your qlik app that represents the fields you wish to use in your PxP report.

Then use that table in your PxP report. For video instructions on this visit https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/design-pixelperfect-templates.htm

Kind regards.

Side note: In order to use 'levels' correctly, you need to use 'levels' exclusively.

Add the fields and charts to 'levels' only.

Then add your fields values found in your charts to the PxP Canvas accordingly.

(note: do NOT use 'tables' unless you are building a PxP native table chart object. 'tables' feature is used for that purpose)

topic Re: How to iterate fields from different tables at the same time? in Reporting Service & Alerting

How to iterate fields from different tables at the same time?

Re: How to iterate fields from different tables at the same time?