Why Only some fields and Objects can be selected under levels in Pixel Perfect Reports??

[Qlikuser09]

I am not able to select some fields  from my table chart under LEvel in Nprinting Pixel perfect . Also I am not able to insert my Qliksense table chart under Levels in Pixel perfect report.

[Lech_Miszkiewicz]

Hi @Qlikuser09 

Have you read documentation and does your table meet all requirements?

Examples of typical problems causing this are:

• use of extension object (not native Qlik Sense straight table)
• use of "show column if" on the fields. This property must be empty!
• use of pivot table (rather than straight table)
• calculated dimensions
  • formulas as dimensions
  • fields starting with "=" sign are also treated as calculate dimensions
  • Master Item dimensions with calculated formula or field starting with = sign

The above are the most common mistakes (I call them rookie mistakes 🤣 as they are just innocent and sometimes you dont notice the issue), so if you have one of those you can smile/laugh and quickly change it and off you go. If it is isn't one of the above we may need more detail about how your table is build (some details about how your table was created - sometimes issues can relate to the fact that your table was "converted from earlier built pivot table or that your table has "Chart suggestions" enabled.

cheers and good luck.

[Lech_Miszkiewicz]

Hi @Qlikuser09 

also - decide which version of NPrinting are you using? Is it May 2021 SR2 or May 2022. Let us know what version of Qlik Sense are you using with it and make sure it is also supported combination of NPrinting vs Qlik Sense. Details are on https://help.qlik.com in NPrinting section.

[Qlikuser09]

My NPrinting Version in May 2022 SR1.

[Lech_Miszkiewicz]

1. and the version of Qlik Sense is what?
2. and have you tested what I mentioned in my first response?

cheers

[Qlikuser09]

It is not a Pivot or Extension Object. But it does have some columns with (= in dimensions as calculations). But will that prohibit the Whole table not showing under the Levels in Pixel Perfect??

[Lech_Miszkiewicz]

yes - absolutely. 

If dimension has = sign it is treated as calculated dimension. Those obviously cannot be looped through (which is what NPrinting levels are doing) as values of calculated dimensions are based on selection state. 

That is in nutshell why = sign in dimensions disqualifies it from being used in level. 

Remove = signs and see for yourself 🙂

cheers

btw - measures are not affected by = sign.