(For E-ticket)-If your ticket remains in WL after chart preparation for any of the above mentioned trains then it'll be automatically canceled.
(For PRS/Counter)- If the ticket is bought from counter then you will have to get it manually canceled if it remains in WL after chart preparation.