SQL to Qlikview

[#1]

All,

Any help on the below part of a query in a view which I have to replicate into Qlikview as it.

I am actually concerned about the joins, I think I can cope up with the Sum()  part columns but joins same table six times with different conditions is problematic, I am using multiple residents and Qualify to achieve this.

Any help ??

[Gysbert_Wassenaar]

I'd leave the SQL statement as it is and send it from Qlikview to the database server for execution:

MyTable:

SQL SELECT ....etc ;

[#3]

Hi Gysbert,

I suggested the same as the query is from a view but due to some reasons They want a data model to be built using this and pity thing is the qvw will hardly contain one or two straight tables.

Can you provide the mimic of it in Qlikview.

Thanks

Kumar