5 Replies Latest reply: Feb 8, 2018 8:03 AM by Ruggero Piccoli RSS

    Input Question

    merthazar sanlier

      Hi All,

       

      I have a question.Could you help to me please

       

      I will do input between two dates

       

      dates;

      01012018

      02012018

      03012018

       

      Input;

      [01012018-03012018]

       

      output;

      01012018+02012018+03012018

       

      How i do?

       

      thank you so much.

        • Re: Input Question
          Ruggero Piccoli

          Hi,

           

          The question is not clear to me. Could you add some details?

           

          Qlik NPrinting has not an input feature, data comes from QlikView or Qlik Sense so you need to add data to the original documents or apps and then Qlik NPrinting will use the data in reports.

           

           

          Best Regards,

          Ruggero

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

          When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

            • Re: Input Question
              merthazar sanlier

              Hi Ruggero,

               

              Thank you for your answer.

              I have 30 excell files.It file names date format.

               

              01.01.2018.xlsx

              02.01.2018.xlsx

              03.01.2018.xlsx

              .....

               

              All of the files are the same format.

              x1

               

              my target;

              I want to entry startdate and enddate .How I can  fetch the sum of all files between two dates

               

              example;

               

              LET vstartdate=Input('startdate');

              LET venddate=Input('enddate');

              LOAD X1
              FROM
              [z:\\mert\Desktop\TEST\(?????).xlsx]
              (
              ooxml, embedded labels, table is Sheet1);

               

              (?????) =What can it here syntax?

               

               

              Thank you again for your help

              Regards

                • Re: Input Question
                  Ruggero Piccoli

                  Hi,

                   

                  This is the Qlik NPrinting community. I would to suggest you to post the question on QlikView community to maximize the provability that somebody helps you.

                   

                  I'm not a scripting expert but I found that "The filename may contain the standard DOS wildcard characters ( * and ? ). This will cause all the matching files in the specified directory to be loaded." in the page Load ‒ QlikView of QlikView help.

                   

                  I hope this helps.

                   

                  Best Regards,

                  Ruggero

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

                  When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.