How to add a sheet to my Pixel Perfect levels?

[artmar]

I'm trying to add a table included in the Printable sheet but I can't find out why. Why is my Catalogue sheet already in Pixel Perfect while Printable is not?

The sheets I haveThe sheets that appear in Pixel Perfect ("Catalogue" only)

[JandreKillianRIC]

Hi @artmar 

What I have noticed is that tables that have Calculated dimensions are not shown. 

Do you have a calculated dimension in that table? 

Regards

[artmar]

Both sheets actually have at least one calculated dimension. I have no idea why Catalogue is in Pixel Perfect's levels while Printable isn't though.

[Frank_S]

Please follow this detailed step by step video which explains how to work with Pixel Perfect levels.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/pixelperfect-c...

Kind regards...

[artmar]

This explains how levels work though, not how to add a sheet to my levels

[JandreKillianRIC]

Hi @artmar 

• are there any calculated dimensions used in those tables? (ones starting with "=" sign) instead simple field reference?
• are you having any conditional hide/show columns in them?  "show column if"?
• are those straight tables?

Regards - Jandre

[Frank_S]

You may add your sheet as an image within a report band.

That is described in the link I shared.

https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/pixelperfect-c...

Kind regards...

[Andrew_Kruger]

Hey @artmar 

It is possible the object selection window has detected some element in the table that are not fit for a level...and if that is the only object in the sheet then the sheet and its objects would not be listed.  

reference - https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/Reporting-serv...

• Using a calculated dimension as a level is not supported. Specifically, the following use cases are not supported:

  • Adding a calculated dimension as a master item, adding this master item to a chart, and then using the chart as a level.

  • Adding a calculated dimension expression to a chart, and then using the chart as a level.

  You can, however, include tabular data consisting of calculated dimension columns inside a level.

You may need to tweak your source table and lean on the PixelPerfect table report creation including calculations and filters etc.  see here https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/Reporting/pixelperfect-h... 

There is also a learning course here - https://academy.talend.com/student/path/2341589-qlik-reporting-creating-reports-with-pixelperfect-ed... 

[artmar · Accepted solution]

@Andrew_Kruger it was indeed because of this. Since I had a column with images, the whole table wasn't showing in the Add Levels panel. Thank you very much!