topic Re: Nprinting level on same page in Qlik NPrinting

Nprinting level on same page

xiuur2508 — Tue, 16 Aug 2016 08:20:35 GMT

Hello

I m new in Nprinting/Qlikview, so go it easy

I have to create a table with several levels on the same page.

I have attached a picture.

1) Is it possible to do it?

2) how ? because i m trying to add level, but i can't loop on the same page.

Have a lovely day !
Thanks

Re: Nprinting level on same page

avinashelite — Tue, 16 Aug 2016 10:20:34 GMT

did you check this thread

How to Create Excel Reports with Nested Levels and Subtotals

Re: Nprinting level on same page

xiuur2508 — Tue, 16 Aug 2016 11:52:30 GMT

Yes i have read it...

I have to use Pixel Perfect, because in each box, i have to use variables and functions.

I can't use excel's report i think.

For now, in PP, i have:
1
2
3

And it's on the same page. What i want, it's columns.

I don't want

Page1:

---------------

Page2:

I want:

Page 1

1 2

Re: Nprinting level on same page

xiuur2508 — Tue, 16 Aug 2016 12:22:06 GMT

Look an exemple....

Re: Nprinting level on same page

avinashelite — Tue, 16 Aug 2016 13:20:42 GMT

In order to achieve this you cannot direct use levels on that field , you need to create an additional field with data like below and then you need to use the levels on the new field ...

1,1
2,1
3,2

4,2

Re: Nprinting level on same page

xiuur2508 — Tue, 16 Aug 2016 13:46:26 GMT

uhhhhh oO ...

I don't understand the answer ( yes, a real noob here... )

How do i create an additional field ? In the view or in Nprinting ?

And i put all my "formulas" in this field ? And then i use lvl...

Re: Nprinting level on same page

Daniel_Jenkins — Tue, 16 Aug 2016 22:55:15 GMT

Hi Florian,

If you post a small sample QVW with data and a mockup report of what output you expect, I'm sure someone will take a look for you.

Best - Daniel.

Re: Nprinting level on same page

avinashelite — Wed, 17 Aug 2016 06:00:41 GMT

Ok, to explain it more . If you use the field1 in levels then in page 1 you will get only the data grouped for 1

i.e. like this

Page1:

in order to achieve the grouping as you mentioned

Page 1

1 2

we need to group the data with new field so that it will display the data related to 1 &2 together in the same page . Other work around is to create multiple charts in Qlikview and import chart in NPrinting

Hope this helps you

Re: Nprinting level on same page

xiuur2508 — Thu, 18 Aug 2016 08:03:08 GMT

Hello, thx for the answer....

For more info: here is my script:

LOAD 
     TroupeauActuel,
     DateNaissance, 
     Sexe, 
     TypeRacial, 
     BOVIN
FROM

(qvd) where RegionTroupeauActuel='WALLONIE' and match(right(TroupeauActuel,4), '0101', '0151')>0;// where Exists(BOVIN, BOVIN);


LOAD 
     ANPP_BOX_MACT_CDE&ANPP_BOX_MRK_NBR_1&ANPP_BOX_MRK_NBR_2 as BOVIN, 
     ANPP_BOX_MRK_NBR_1,
     ANPP_BOX_MRK_NBR_2,
     ANPP_BOX_MACT_CDE as code_pays,
     ANPP_VRS_NBR as passport_nbr,
     ANPP_BOX_MRK_CDG as chk_digit,
     ANPP_BOX_ANM_HRT as robe

     
FROM

(qvd) ;

So in TroupeauActuel, there are Bovin (1 to 100 Bovin)

Everything i load here is one on value of output. BE PBL F Viandeux.....

In my output:

So what i need in Nprinting is:
Each box, is a bovin, and each bovin has a TroupeauActuel.
Nprinting has to loop for all bovin (for one TroupeauActuel)
Next, he has to loop for all TroupeauActuel.

And for the output, all in the same page, when he has done 5 column * 30 line, it continue on the next page.
Without empty box.

I don't know if u understand the problem. I will try to group data on a new fields.