8 Replies Latest reply: Aug 18, 2016 4:03 AM by Florian lequeux RSS

    Nprinting level on same page

    Florian lequeux

      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
            Florian lequeux

            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

          • Re: Nprinting level on same page
            Florian lequeux

            Look an exemple....

            azeazeaze.png

            • Re: Nprinting level on same page
              Florian lequeux

              Hello, thx for the answer....

               

              For more info: here is my script:

               

              LOAD 
                   TroupeauActuel,
                   DateNaissance, 
                   Sexe, 
                   TypeRacial, 
                   BOVIN
              FROM
              [D:\QLIKVIEW\PROD\QVD\SANITRACE\QVD_TRANS\1_Animal\ANIMAL_trans.qvd]
              (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
              [D:\QLIKVIEW\PROD\QVD\SANITRACE\QVD_RAW\ANIMALPASSPORT.qvd]
              (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.