Does HANA understand the word SUBSELECT? It's not standard sql afaik. Perhaps SELECT instead of SUBSELECT works.
Anyway, this is a problem in the sql statement and it has nothing to do with qlikview. All qlikview does is pass the sql statement to the odbc driver. It's up to the driver and database system to process the statement and return the results.