Qlik Community

QlikView Extensions

Discussion Board for collaboration on QlikView Extensions.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
darrihilmarsson
New Contributor II

Skip data

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

1 Solution

Accepted Solutions
Luminary
Luminary

Re: Skip data

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

11 Replies
MVP
MVP

Re: Skip data

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

Luminary
Luminary

Re: Skip data

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

JV

Highlighted
darrihilmarsson
New Contributor II

Re: Skip data

Juan, what did you?

I can't see it

Luminary
Luminary

Re: Skip data

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

MVP
MVP

Re: Skip data

Replace

= Min(Date) with below

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

darrihilmarsson
New Contributor II

Re: Skip data

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?

Luminary
Luminary

Re: Skip data

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

MVP
MVP

Re: Skip data

Hi Darri,

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

Luminary
Luminary

Re: Skip data

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

Community Browser