Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
Highlighted
Not applicable

Expression - returning the desired field

Hi,

The below expression returns an Audit Update ID record.

aggr(num(max([Audit Update ID],2)),[Update ID],[Action Item ID])

I would like to use the above expression to get the correct Audit Update ID (which it does), and then use this to return another field value (% complete).

Any help in how I structure this would be greatly appreciated.

Thanks,

Alan