Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
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

0 Replies