6 Replies Latest reply: Nov 30, 2012 4:23 AM by sandston RSS

    To count amount of records that corresponds to date

      I would like to know how I would go about producing within Qlikview the image below.

       

      My data set has records for each day ranging from 40 - 250 (for both arrivals and departures) The details shown below are for departures only so an If statement would definitely need to be constructed.

      If date and if departure count each record output total count. this would then be displayed as Total Mvnts, I have a column called Delay Mins already within Qlikview which calculates the difference between two time sets, I then want Qlikview to count each record that has a delay min of anything equal to or greater than 15.

       

      sample.png

       

      I have attached the data file I am working from, I am unable to load files as I am using the personal free edition, so please can any advice be advised through here. Thanks