11 Replies Latest reply: Jul 3, 2015 12:14 PM by Darri Hilmarsson RSS

    Skip data

    Darri Hilmarsson

      Hi, QV community

       

      I have one issue that I need help to solve.

      I have a sample of the dataset below.

       

       

      Every Job Ref has two dates and I only want the first date.

      Also I want the Job Ref that has Revenue larger than zero to show in the chart.

       

      So if you look at the data below I want my chart in qlikview to show Job Ref SIS231161 and SIS231532.

      And for the job ref I want the Min(Date). So for Job Ref SIS231161 I want the date 16.01.2014 and Job Ref SIS231532 I want the date 16.01.2014

       

        

      Job RefCharge CodeRevenueDate
      SIS231161FWD475,0016.01.2014
      SIS231161FWD475,0020.01.2014
      SIS231413-0,0016.01.2014
      SIS231413-0,0020.01.2014
      SIS231532FWD38,7216.01.2014
      SIS231532FWD38,7223.01.2014
      SIS231688-0,0016.01.2014
      SIS231688-0,0025.01.2014