3 Replies Latest reply: May 19, 2016 12:32 PM by Jeremy Latimer RSS

    for loop in qlikview with dates

    Pedro Lopes

      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