topic Re: for loop in qlikview with dates in QlikView

for loop in qlikview with dates

Anonymous — Wed, 11 May 2016 23:08:05 GMT

Hi,

Can you help me with this?

LET y=Date(Num#(Today()));

FOR i=Date(Num#('2015-01-01','YYYY-MM-DD')) to '$(y)'

Fact_apk_appdownloads:

Load*;

SQL SELECT "added_date",

"app_package",

"downloads",

"id",

"store_id"

FROM "aptstats_db"."stats_apk_appdownloads"."data_ed418c0c40177ea81381dd993e9f9cd82cb169aa_$(i)";

STORE * FROM Fact_apk_appdownloads into ..\QVD Generator\QVD Generator aptoide_db\Fact_apk_appdownloads\Fact_apk_appdownloads_$(i).qvd;

DROP Table Fact_apk_appdownloads;

NEXT i

CELAMBARASAN — Thu, 12 May 2016 13:34:11 GMT

I have modified your script based on your need. Please check whether it works for you

LET y = Today();

For i = Date(Date#('2015-01-01','YYYY-MM-DD')) to y

LET vFileDate = Date(i, 'YYYY-MM-DD');

Fact_apk_appdownloads:

Load*;

SQL SELECT "added_date",

"app_package",

"downloads",

"id",

"store_id"

FROM "aptstats_db"."stats_apk_appdownloads"."data_ed418c0c40177ea81381dd993e9f9cd82cb169aa_$(vFileDate)";

STORE * FROM Fact_apk_appdownloads into ..\QVD Generator\QVD Generator aptoide_db\Fact_apk_appdownloads\Fact_apk_appdownloads_$(vFileDate).qvd;

DROP Table Fact_apk_appdownloads;

NEXT i

Anonymous — Thu, 19 May 2016 16:25:55 GMT

Thank you it's work

Anonymous — Thu, 19 May 2016 16:32:57 GMT

Hi Pedro,

Please take a moment to mark Celambarasan's reply as Correct by following the steps outlined here: Qlik Community Tip: Marking Replies as Correct or Helpful

Thank you,

Qlik Community Team