Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
Showing results for 
Search instead for 
Did you mean: 
Creator II
Creator II

Is it possible to assign a variable to a band or table in a Pixel Perfect report?

As always, I appreciate your enormous help.

I have a Qlik Sense table which has a dimension determined by a variable and a measure. Something like the image 1 and 2. I want to know if it's possible to assign a variable to a band or table in order to reuse the same table several times on the same report.

Image 1. Region as $(vDim)Image 1. Region as $(vDim)

Image 2. Country in $(vDim)Image 2. Country in $(vDim)

Image 3. Structure of the dataImage 3. Structure of the data

Image 4. Variable definitionImage 4. Variable definition





Labels (2)
1 Reply

Hi @julioarriaga 

First question is: What do you want to do with this trable?

If your goal is to use it as an actual table in PixelPerfect report then you have to ask yourself another question: Are calculated dimensions possible in the pixel perfect levels where table needs to be put. Answer is - they are not! So that is big no! https://help.qlik.com/en-US/nprinting/May2021/Content/NPrinting/ReportsDevelopment/Qlik-objects-supp...

On the other hand if your goal is to use that table as source for chart or as image then yes - you can achieve it by making in your Qlik Sense data model island table which will hold values which when selected could control your dimension in table.

Filtering in such manner is described in this topic: https://community.qlik.com/t5/Qlik-NPrinting-Discussions/How-to-apply-an-object-level-filter-in-pixe...

Note that it seems that you cannot set variable value directly in Pixel Perfect template (like variable filter) as you can only apply filters on "Data Members" and it seems only levels are part of it.



cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.