12 Replies Latest reply: Sep 23, 2016 10:13 AM by Ganesh Bagavathi RSS

    Dates, columns to rows, Scripting help needed

    Ga Baga

      Hello All,


      I have a complex requirement, any suggestion is much appreciated.


      What I have:

      A file with Monthly values, e.g: For a Line of Business A, June Amount is xxx $

      I have a Qlikview dashboard with Facts and Dimensions and this file has to be handled directly by Qlikview but rest of the tables come from a database

      A single LOB can have multiple Entities


      What I need:

      I will have to split the Monthly amount into Weeks and then into days omitting the weekends

      I will have to introduce the dates according to the month mentioned in the file e.g. for June 2016, i will have to introduce dates for weekdays.

      I will have to introduce rows for each date and for each LOB and each Entity


      Please refer to the attached excel and let me know if more information is needed.