Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
artmar
Partner - Contributor III
Partner - Contributor III

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

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 levels4 fields from 4 different levels

Labels (1)
1 Solution

Accepted Solutions
Frank_S
Support
Support

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-pixelpe...

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)

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

1 Reply
Frank_S
Support
Support

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-pixelpe...

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)

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!