I tried to use 'with' clause sql statement in data load editor but qliksense cannot recognise. Is it because 'with' is not recognised by qlik or I have made a mistake?
Do you have a ODBC connection? I think you might need ODBC, if you don't have that. Also, look here if this thread can provide any information: how to use with clause (pl sql) in qlikview
Add SQL in front of 'with' for my case to make it work.
Retrieving data ...