topic Re: SQL Queries in QlikView

SQL Queries

Wed, 13 Jun 2012 09:03:29 GMT

Hi All

I have attched SQL query.

Please let me know can I decode this query to map all the logic of query in qlikview.I am not supposed to do directly run the query.

Can anyone tell me what can I do for this query?

I don't have any requirement document. I need to decode the query to pull out requirement.

How can proceed with this query. I'm confused.

Please help me regatding this.

Regards,

Kushal

Re: SQL Queries

deepakk — Wed, 13 Jun 2012 09:11:47 GMT

hi Kushal,

Running this query will have performance issue. Do the following activites.

1) Analyze the number of tables. Pull each one into a single qvd;

2) Understand teh joins between this tables and try to join them using the qvd.

3) Use the where clause on necessary tables.

4) take out only the necessry fields as required in the script.

Deepak

Re: SQL Queries

Wed, 13 Jun 2012 11:01:32 GMT

Hi Deepak,

Thanx for the reply.

But it's very difficult to find the joins between table as the query is complex.

Re: SQL Queries

Wed, 13 Jun 2012 11:02:00 GMT

Hi Deepak,

Thanx for the reply.

But it's very difficult to find the joins between table as the query is complex.

Regards,

Kushal

Re: SQL Queries

Wed, 13 Jun 2012 11:02:04 GMT

Hi Deepak,

Thanx for the reply.

But it's very difficult to find the joins between table as the query is complex.

Regards,

Kushal

Re: SQL Queries

Wed, 13 Jun 2012 11:02:16 GMT

Hi Deepak,

Thanx for the reply.

But it's very difficult to find the joins between table as the query is complex.

Regards,

Kushal

Re: SQL Queries

deepakk — Wed, 13 Jun 2012 11:11:30 GMT

hi Kushal,

I understand that. Once you break down the code , you will get it.. It will take time.

Best of Luck

Deepak