for loop in qlikview with dates

[Anonymous]

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]

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]

Thank you it's work

[Anonymous]

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