I'd really appreciate it if anyone could spot the error here and put me on the right course.
Thanks in advance.
P.S I realise I can do this in Qlikveiw as a calculated dimension. However, the next chart which I will require will need it through this partial reload and a calculated dimension will not be possible. I'd like to sort out the problem before it arises.