0 Replies Latest reply: Jul 30, 2012 8:44 AM by harry_hhs RSS

    Load data into qlikview

      Hello,

       

      I hope someone will be able to help me; i want to do the following thing:

       

       

      I want to create a table in Qlikview wich stores data per reload (no refresh) Why? I want to make a chart wich displays how many incidents there where open in for example week 1.

       

      Currently i can only show wich incidents are currently open by doing a simple expression:

       

      if ( IN_closed='0', Count({< IN_number = {"=Today() - Date(IN_DATE_creation_date) <= 7"} >} IN_number))
      

       

      But i want to have an archive, now when an incident gets closed IN_closed will have the value '1'.  so i'm not able to see how many incidents where open in week 1 for example.

       

      So basicly i want a static table (log) in qlikview wich contains the following information.

       

      IN_numberweek()IN_DATE_creation_date
      IN_closed
      001101/01/20120
      001201/01/20120
      001301/01/20120
      001401/01/20120

       

      by having this information stored i can make an chart wich displays that there is 1 incident open during the period of 4 weeks.

       

       

      Thanks.