Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Highlighted
benvatvandata
Contributor

Straight Chart - Aggregating Data

Hi,

I'm having trouble aggregating this data on one row (see attachment)... Bill Number 700077 is a credit (credit = 1) if that helps...

 

Thanks,

Ben

 

2 Replies

Re: Straight Chart - Aggregating Data

Like this?
Firstsortedvalue(BillNo, -Aggr(Measure, dim1, dim2))
Life is so rich, and we need to respect to the life !!!
benvatvandata
Contributor

Re: Straight Chart - Aggregating Data

This just seems to return the Credit Bill Number (not the summed up values shown in my 1st attachment)?

Just for clarification, I keep my 3 dimensions as: Bill Number, Bill Original BillNum, and Bill Replacement BillNum correct?