topic Re: Skip data in QlikView

Skip data

Anonymous — Mon, 26 Jan 2026 16:26:21 GMT

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
SIS231161	FWD	475,00	16.01.2014
SIS231161	FWD	475,00	20.01.2014
SIS231413	-	0,00	16.01.2014
SIS231413	-	0,00	20.01.2014
SIS231532	FWD	38,72	16.01.2014
SIS231532	FWD	38,72	23.01.2014
SIS231688	-	0,00	16.01.2014
SIS231688	-	0,00	25.01.2014

Re: Skip data

MK_QSL — Fri, 03 Jul 2015 14:16:50 GMT

=Aggr(Min(Date),[Job Ref])

Re: Skip data

jvitantonio — Fri, 03 Jul 2015 14:32:38 GMT

Hi, this could be different depending on what you want to show. I attach a solution with your example.

Re: Skip data

Anonymous — Fri, 03 Jul 2015 14:37:18 GMT

Juan, what did you?

I can't see it

Re: Skip data

jvitantonio — Fri, 03 Jul 2015 14:42:21 GMT

The table on lthe left. Shows min date with revenue > 0

Re: Skip data

MK_QSL — Fri, 03 Jul 2015 14:47:55 GMT

Replace

= Min(Date) with below

=Aggr(Min(Date),[Job Ref])

Re: Skip data

Anonymous — Fri, 03 Jul 2015 14:53:54 GMT

I understand that the table on the left shows only Job Ref with revenue > 0.

But I can't see what you did to get that result.

What did you change?

Re: Skip data

jvitantonio — Fri, 03 Jul 2015 14:59:12 GMT

I changed the expression on right table. I changed it slightly. Check this app.

Re: Skip data

MK_QSL — Fri, 03 Jul 2015 15:25:19 GMT

Hi Darri,

You don't even tried my solution, which is also giving the same result.

Re: Skip data

jvitantonio — Fri, 03 Jul 2015 15:37:20 GMT

Manish, you are already a MVP, leave something for the rest

Re: Skip data

MK_QSL — Fri, 03 Jul 2015 15:39:49 GMT

LOL !

I asked you not for points but just to let you know that my solution was similar to your approach (Calculated Dimension)... !

Anyway, important is question is answered !

Happy Qliking 🙂

Re: Skip data

Anonymous — Fri, 03 Jul 2015 16:14:33 GMT

Hi, Manish

I tried it but it did not work