topic Re: How to add a sheet to my Pixel Perfect levels? in Reporting Service & Alerting

How to add a sheet to my Pixel Perfect levels?

artmar — Tue, 14 Jan 2025 10:53:43 GMT

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)

Re: How to add a sheet to my Pixel Perfect levels?

JandreKillianRIC — Tue, 14 Jan 2025 10:55:40 GMT

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

Re: How to add a sheet to my Pixel Perfect levels?

artmar — Tue, 14 Jan 2025 13:03:02 GMT

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.

Re: How to add a sheet to my Pixel Perfect levels?

Frank_S — Tue, 14 Jan 2025 19:12:31 GMT

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-create-level.htm

Kind regards...

Re: How to add a sheet to my Pixel Perfect levels?

artmar — Wed, 15 Jan 2025 09:33:20 GMT

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

Re: How to add a sheet to my Pixel Perfect levels?

JandreKillianRIC — Wed, 15 Jan 2025 09:43:01 GMT

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

Re: How to add a sheet to my Pixel Perfect levels?

Frank_S — Wed, 15 Jan 2025 16:39:59 GMT

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-create-level.htm

Kind regards...

Re: How to add a sheet to my Pixel Perfect levels?

Andrew_Kruger — Wed, 15 Jan 2025 18:08:16 GMT

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-service-specifications-limitations.htm

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-highly-formatted-table.htm

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

Re: How to add a sheet to my Pixel Perfect levels?

artmar — Thu, 16 Jan 2025 14:24:23 GMT

@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!