topic Input Question in Qlik NPrinting

Input Question

mert1917 — Thu, 08 Feb 2018 06:52:09 GMT

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 — Thu, 08 Feb 2018 09:27:28 GMT

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

mert1917 — Thu, 08 Feb 2018 11:21:50 GMT

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.

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

(ooxml, embedded labels, table is Sheet1);

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

Thank you again for your help

Regards

Re: Input Question

Ruggero_Piccoli — Thu, 08 Feb 2018 11:29:03 GMT

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

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

Re: Input Question

mert1917 — Thu, 08 Feb 2018 12:31:50 GMT

Ok Ruggero thanks

I did this but it did don't work

LET date='>='&$(=vstartdate)&'<='&$(=venddate);

Re: Input Question

Ruggero_Piccoli — Thu, 08 Feb 2018 13:03:02 GMT

Maybe you can upload all files and apply filters after.