Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

geminihzh
Valued Contributor

using formula in nprinting

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:

ABCDE
1
2Report Time:
3
4<Name_Level>
5
6<Name>
7
8
9Report 1
10C1C2C3C4New Column
11<CH23_Level>
12<C1><C2><C3>

<C4>

=B12/VLOOLUP("Total";A4:B16;2;FALSE)
13</CH23_Level>
14Total=SUM(B11:B13)
=SUM(C11:C13)
15
16</Name_Level>

2. generated report:

ABCDE
1
2Report Time:
3
4<Name_Level>
5
6<Name>
7
8
9Report 1
10C1C2C3C4New Column
12Name121a=B12/VLOOLUP("Total";A12:B16;2;FALSE)
13Name232b=B13/VLOOLUP("Total";A13:B16;2;FALSE)
14Name343c=B14/VLOOLUP("Total";A14:B25;2;FALSE)
15Name453d=B14/VLOOLUP("Total";A15:B26;2;FALSE)
16Name565e=B16/VLOOLUP("Total";A16:B27;2;FALSE)
17Total2014f
18
20</Name_Level>
Tags (2)
1 Reply
Highlighted
geminihzh
Valued Contributor

Re: using formula in nprinting

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

Community Browser