topic Re: nPrinting remove dimension in Qlik NPrinting

nPrinting remove dimension

bobbydave — Thu, 02 Mar 2017 13:54:46 GMT

I'm wondering if this can be done.

I have 3 charts that make up a sheet in excel

Header 1	Header 2	Header 3	Header 4	Header 5	Header 6
Dimension	x	Dimension	y	Dimension	z

Within nPrinting, my 3 charts will appear as below. What I want to do is to not have the dimensions of each chart appearing so I just have the expression from chart 2 and 3 appearing with the dimensions of chart 1 appearing

Header 1	Header 2	Header 3	Header 4
Dimension	x	y	z

Is this possible?

Re: nPrinting remove dimension

avinashelite — Thu, 02 Mar 2017 14:30:48 GMT

You need to achieve this in QV NPritning doesn't provide you such options

Re: nPrinting remove dimension

mkelemen — Thu, 02 Mar 2017 14:58:28 GMT

Hi David,

you can do it if you are using straight tables (you must have the same values and same order in Dimension). You can use selected columns from these tables and put them next to each other.

Your other Option in Excel would be to use vlookup but in that case it is probably better to do it in QV.

BR,

Matus

Re: nPrinting remove dimension

bobbydave — Fri, 03 Mar 2017 11:22:51 GMT

All expressions in all charts are the same.

I will try straight tables. The expressions though, appear in a horizontal line, not in a vertical line which is how i need them all to appear. I'm trying to drag them to the vertical postion.

Re: nPrinting remove dimension

avinashelite — Fri, 03 Mar 2017 11:38:43 GMT

Build the the chart in QV and import the same in NPrinting that would be the better solution