4 Replies Latest reply: Mar 3, 2016 1:25 PM by Omosalewa Aderonmu RSS

    Iterate Defined Days of The Week with Qlikview WeekDays

    Omosalewa Aderonmu

      Community-

      I have a script that loads data from an excel file with the days of the week as "Day" already defined as "Monday, Tuesday, Wednesday, Thursday, Friday".

       

      Table:

      LOAD   Day,

                  Topic,

                  StoreTalk

      FROM

      [..\QVD\Table.qvd]

      (qvd);

       

      I am trying to display these days in iteration with the regular Qlikview week days so as to automate the process and not have to change the "Day" everyday to the days extracted from the excel file in the definition tab or use in an expression.

      Please, any help will be highly appreciated.

      Thanks all.

      Table.JPG