Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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
jvitantonio
Luminary Alumni
Luminary Alumni

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

View solution in original post

11 Replies
MK_QSL
MVP
MVP

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

jvitantonio
Luminary Alumni
Luminary Alumni

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

JV

Anonymous
Not applicable
Author

Juan, what did you?

I can't see it

jvitantonio
Luminary Alumni
Luminary Alumni

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

MK_QSL
MVP
MVP

Replace

= Min(Date) with below

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

Anonymous
Not applicable
Author

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?

jvitantonio
Luminary Alumni
Luminary Alumni

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

MK_QSL
MVP
MVP

Hi Darri,

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

jvitantonio
Luminary Alumni
Luminary Alumni

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