topic Re: For loop not working in QlikView

For loop not working

deepakqlikview_123 — Sat, 16 Nov 2024 17:40:37 GMT

Hi All,

I am fetching publisher log information from the server. However, the for loop is not working.

only whatever mentioned in the variable, can fetch the respective logs.

Actually, need to fetch the Tasklog information for the last 7 days but only 1-day of information is visible.

Attached is the file for the same.

Need some advice on this.

Thanks in advance.

Re: For loop not working

Anil_Babu_Samineni — Wed, 23 Dec 2020 10:55:20 GMT

You have given half question, We don't know what to checka and which is not working. Would you like to rephrase your question?

Re: For loop not working

deepakqlikview_123 — Wed, 23 Dec 2020 12:08:10 GMT

updated the comment,

Re: For loop not working

Anil_Babu_Samineni — Wed, 23 Dec 2020 15:17:40 GMT

You are using only one date in the variable?

Let yesterdate = Date(Today()-1, 'YYYYMMDD');

But also, I can see that you are doing too much for that, I would rather use simply like this

Let yesterdate = Date(Today()-1, 'YYYYMMDD');

Let weekbackyesterdate = Date(Today()-8, 'YYYYMMDD');

for each Tasklog in FileList('D:\Publisher Logs\1\Log\TaskLog.txt')

RLdata:
LOAD '$(Tasklog)' as FileName,
@1,
@2,
@3

FROM $(Tasklog)
(txt, utf8, no labels, delimiter is '\t', msq) Where Field>=$(weekbackyesterdate) and Field<=$(yesterdate);

Re: For loop not working

deepakqlikview_123 — Wed, 23 Dec 2020 15:46:11 GMT

May I know the Field in the above logic? and the field column is not there in the original table.

Re: For loop not working

Anil_Babu_Samineni — Wed, 23 Dec 2020 15:52:54 GMT

Field is something about you want to compare with date field.

Re: For loop not working

deepakqlikview_123 — Wed, 23 Dec 2020 16:05:17 GMT

But where to fetch the field. that is not available in the table.

Re: For loop not working

Anil_Babu_Samineni — Wed, 23 Dec 2020 16:20:05 GMT

Can you share the file name as an example so that i can give complete script?

Re: For loop not working

deepakqlikview_123 — Wed, 23 Dec 2020 16:46:46 GMT

PFA.

The file is in different folders and the nested for loop is required to fetch data from them.

Re: For loop not working

Anil_Babu_Samineni — Fri, 25 Dec 2020 18:12:51 GMT

Check all these If something can be achieved via Sub routine? Here

Re: For loop not working

deepakqlikview_123 — Mon, 28 Dec 2020 04:21:49 GMT

Hi,

The code is as excepted but the for loop is not working. Could you please advise on this.

Attached is the file for the same.

Thanks

Re: For loop not working

Anil_Babu_Samineni — Mon, 28 Dec 2020 10:17:54 GMT

I am not able to reload your application but Subroutine will deserve ..

Re: For loop not working

antose — Tue, 29 Dec 2020 14:32:00 GMT

Hi! I'm doing similar in one of my "following up" applications. This is how I have done it (read all the distribution log files, default 31 days)