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 Ref||Charge Code||Revenue||Date|
Solved! Go to Solution.