topic Use hidden column in PixelPerfect Report in Qlik NPrinting

Use hidden column in PixelPerfect Report

sebastianlettner — Fri, 10 Jul 2015 10:13:29 GMT

Hallo,

i need to format rows in a Straight Table Chart based on the value in a field but the field should not be visible.

I already created the Chart and added the field as dimension an selected Hide Column at the Presentation tab. When I use the Chart in NPrinting the Column is not listed.

Is there a way to get the value?

The Table looks like this:

Description	Format (Hidden)	Data
A	0	100
B	0	200
C	1	300
D	2	400
F	3	500

Thanks for your help.

Re: Use hidden column in PixelPerfect Report

Andrea_Ghirardello — Mon, 20 Jul 2015 13:34:26 GMT

Hi,

You should make it visible in QlikView in order to use it into NPrinting.

Re: Use hidden column in PixelPerfect Report

avinashelite — Mon, 20 Jul 2015 13:39:40 GMT

no their is no way that you can get the hidden column in the chart in NPrinting , you need to enable the chart in the NPrinting .

Their is one way to achieve this :

Create one more chart with all the fields , then first in NPrinting add this object in template than go to Qlikview and hide this chart >for Qlikview it will be hidden for NPrinting since you have added the ID before hiding it will be able to fetch the chart.

NOTE: First add the chart in NPrinting and then hide it in the Qlikview