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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Addition and deletion to get the output.

Hi all,

Please find attached sample application and data.

logic:we are comparing the latest month date with previous month date.

1.The cust who are present in latest month and not in previous month as addition,

2.The cust who are present in previous month and not in current month as deletion

3 remaing all are null i.e cust present in both the date.

Regard

Arun Reddy

2 Replies
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

See attached qvw. Your data is not very clear. There are no weeks, but two dates from two different months. And your employees seem to change their names during time. So I could only use the two dates 'hardcoded' in the expressions and only the EMPLID as dimension.


talk is cheap, supply exceeds demand
Anonymous
Not applicable
Author

Hi Gysbert,

Thanks for replay,

Please attached the qvw file, we need to create the new field ie output in back end.

logic is clear :

consider the latest month is 'Jan' compare with previous month 'Dec' ,if new employees added in the latest month as addition,some of the employees left the job as deletion,

Thanks

Arun Reddy