Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

xiuur2508
Not applicable

Nprinting level on same page

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


8 Replies
avinashelite
Not applicable

Re: Nprinting level on same page

xiuur2508
Not applicable

Re: Nprinting level on same page

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

4

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

I don't want


Page1:

1

1

1

1

1

1

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

Page2:

2

2

2

2

2

2

I want:

Page 1

1 2

1 2

1 2

1 2

1 2

xiuur2508
Not applicable

Re: Nprinting level on same page

Look an exemple....

azeazeaze.png

avinashelite
Not applicable

Re: Nprinting level on same page

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

xiuur2508
Not applicable

Re: Nprinting level on same page

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...

Daniel_Jenkins
Not applicable

Re: Nprinting level on same page

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.

avinashelite
Not applicable

Re: Nprinting level on same page

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:

1

1

1

1

1

1

in order to achieve the grouping as you mentioned

Page 1

1 2

1 2

1 2

1 2

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

xiuur2508
Not applicable

Re: Nprinting level on same page

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: 

azeazeaze.png

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.

Community Browser