topic Re: Table not appearing in Levels in Qlik NPrinting

Table not appearing in Levels

JustinDallas — Fri, 09 Jun 2023 14:48:50 GMT

Hello Folks,

We are on NPrinting May 2022 SR2. I have a table in QlikSense that does not appear in the Levels selector, but does appear in the Tables selection.

What could be the cause of this?

Any help is greatly appreciated.

Re: Table not appearing in Levels

Lech_Miszkiewicz — Fri, 09 Jun 2023 14:56:04 GMT

Hi. The obvious reason would be calculated dimension which would be not supported in levels. Note that having field starting with “=“ sign is considered as calculated dimension too…

cheers

Re: Table not appearing in Levels

Lech_Miszkiewicz — Fri, 09 Jun 2023 15:00:18 GMT

Ohh and one more-check if you use conditional show/hide on columns which would disqualify table from levels and in tables would bring table as a whole table tag and not individual columns tags.
cheers

Re: Table not appearing in Levels

Lucas_Gatling — Fri, 09 Jun 2023 15:06:43 GMT

@JustinDallas see the following KB articles for all unsupported items in Nprinting: https://community.qlik.com/t5/Official-Support-Articles/Qlik-NPrinting-Unsupported-QlikView-Document-items-System/ta-p/1714896

Re: Table not appearing in Levels

JustinDallas — Fri, 09 Jun 2023 15:20:37 GMT

Got it =( .

I assume a Set Analysis measure also will keep the chart from being brought in too right? I'm considering doing all the calculations in the datamodel to make actual fields in the table instead of using Set Analysis.

Do you think that's a reasonable workaround?

Thanks for the super-fast response.

Re: Table not appearing in Levels

Lech_Miszkiewicz — Fri, 09 Jun 2023 15:26:28 GMT

Measure is not a problem - only dimensions with = sign. Reason is obvious-levels “cycle” through dimension values (not measure values) when table is in level…

Re: Table not appearing in Levels

Lech_Miszkiewicz — Fri, 09 Jun 2023 15:39:21 GMT

Moving calculations to data model is only necessary if it affects dimension values. I often use set analysis to ensure that levels cycle only through dimension values which return measure i want-or are suppressing values i dont want to see.

the only scenario where set analysis may cause issues is when selection state caused by filters removes certain values from possible in selection state, but set analysis overwrites it and makes them visible in table-that may not work properly in level then.

Re: Table not appearing in Levels

JustinDallas — Fri, 09 Jun 2023 18:32:47 GMT

You were right, as expected, those equal signs were what was messing everything up. I had to remove them outside of the expression editor viewed by hitting the fx button. Thanks a lot Lech!

Re: Table not appearing in Levels

Lech_Miszkiewicz — Fri, 09 Jun 2023 23:45:59 GMT

That is correct - clicking at f(x) causes it to be expression/calculated dimension by default.