using formula in nprinting

Anonymous — Thu, 07 Apr 2016 11:49:57 GMT

Hi, all,

I am creating a nprinting excel template (see below 1.template).

I use a excel formula in column E. And this only works sometime.

The search area "A4:B16" in the template changes in the generated report. The "A" part is correct, and do follow a rule,

but the "B" part changes "random". Half of the rows cover the table, half of it dose not. I say it is random, because I can not see the rule for the "B" part. It can jump like in my example below from "B16" to "B25" (2. generated report). And for different reports, sometimes, if the table has less rows, then first row of the "B" part can cover the whole table. But if the table is bigger, the "B" part for the first few rows can not cover the whole table, then it can not get the value of the "Total" column.

As I use the row number of the <Name_Level> and </Name_Level> in the template. I thought the "B" part should be the end of the report, but it seems not the case. Dose any one has any idea?

Thanks very much

Zhihong

1. template:

Report Time:

<Name_Level>

<Name>

Report 1

New Column

<CH23_Level>

<C1>

<C2>

<C3>

<C4>

=B12/VLOOLUP("Total";A4:B16;2;FALSE)

</CH23_Level>

Total

=SUM(B11:B13)

=SUM(C11:C13)

</Name_Level>

2. generated report:

	A	B	C	D	E
1
2	Report Time:
3
4	<Name_Level>
5
6	<Name>
7
8
9	Report 1
10	C1	C2	C3	C4	New Column
12	Name1	2	1	a	=B12/VLOOLUP("Total";A12:B16;2;FALSE)
13	Name2	3	2	b	=B13/VLOOLUP("Total";A13:B16;2;FALSE)
14	Name3	4	3	c	=B14/VLOOLUP("Total";A14:B25;2;FALSE)
15	Name4	5	3	d	=B14/VLOOLUP("Total";A15:B26;2;FALSE)
16	Name5	6	5	e	=B16/VLOOLUP("Total";A16:B27;2;FALSE)
17	Total	20	14	f
18
20	</Name_Level>

Re: using formula in nprinting

Anonymous — Thu, 07 Apr 2016 12:32:14 GMT

I finally make it work after use big enough value for "B" part in the template, like "A4:B300", but not use the row number of <Name_Level> and </Name_Level> in the template. As my VLOOKUP() formula only need to use the value from the first match, so it dose matter if there are multiple match, so I do not need to control the search area of VLOOKUP(). But still have no idea the rule for the "B" part here.

Zhihong

topic using formula in nprinting in Qlik NPrinting

using formula in nprinting

Re: using formula in nprinting