topic Re: SQL to Qlikview in QlikView

SQL to Qlikview

Mon, 25 Apr 2016 16:05:02 GMT

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 ??

Re: SQL to Qlikview

Gysbert_Wassenaar — Mon, 25 Apr 2016 16:44:13 GMT

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

MyTable:

SQL SELECT ....etc ;

Re: SQL to Qlikview

Mon, 25 Apr 2016 17:53:05 GMT

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