topic Re: Input&From in QlikView

Input&From

mert1917 — Fri, 09 Feb 2018 06:22:12 GMT

Hi everyone,

I have a question.Could you help to me please..

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?

I did this but it did don't work

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

Thank you.

Re: Input&From

tresB — Fri, 09 Feb 2018 06:50:29 GMT

Try something like:

For Each File in FileList(vPath &'\??.??.????.xlsx')

Let vDate = Date#(Left(File, 10), 'MM.DD.YYYY');

If vDate >= vstartdate and vDate <= venddate Then

<Load Statement>

End If

Next

Note: you might have to format the input dates to convert it to proper date format.

Re: Input&From

mert1917 — Fri, 09 Feb 2018 08:46:24 GMT

Hi Tresesco,

Thank you so much for helping to me.

I checked but syntax not working

How can i do?

regards

Set vPath = 'C:\Users\mert.sanlier\Desktop\TEST\';

LET vstartdate=Input('startdate');

LET venddate=Input('enddate');

For Each File in FileList(vPath &'\??.??.????.xlsx')

Let vDate = Date#(Left(File, 10), 'DD.MM.YYYY');

If vDate >= vstartdate and vDate <= venddate Then

LOAD X1

FROM

(ooxml, embedded labels, table is Sheet1);

End If

Next