Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
aravindkumarr
Contributor III
Contributor III

How to carry forward the backlog value and calculate the value for 'Hired on backlog'

Hi,

Scenario 1:

How to carry forward my backlog value (Target - (Total Hired)) of the first row to the second row of a particular key?

For a same key. if there's a backlog value, then it is forwarded to the next row of the same key.

Scenario 2:

If there's a backlog value, then if any hiring takes place for the particular month, then my value of Hired (Count(Candidate_ID) based on Key) should be placed in Hired on Backlog.

This is the sample output. I have also attached a sample dataset. Please help

Capture.PNG

0 Replies