Thanks Patrick for your reply.
Your suggestion is a good workaround, in this case I would have to write script to modify the table ore create a veiw and add that extra column to the table/view then import the data into Qlik.
Can you please suggest if Qlik data manager can somehow do this.
Also after reading up a little bit it seems it can be achieved through a Geoanalytic connector but I yet have to verify with sales and support team how to get there. Because I was not able to find any option in QMC, HUB or Data manager.