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

Number Fields

Hi

How do I number the inspections for each PMP_CODE so, as an example, I can then retrieve the last two inspections done on each property (denoted by PMP_CODE)?

Property & Inspections.PNG

Outcome would be:

Property & Inspections2.PNG

1 Reply
muniyandi
Creator III
Creator III

hi kieran,

in expression give, 1 and select full accumulation.

kindly check the attachment file.

Muni