topic Re: running complex SQL query in QV in QlikView

running complex SQL query in QV

Mon, 01 Sep 2014 13:26:25 GMT

Hi all, I'm new to QlikView and I'm using SQL server DB for data, my question is the following: Can I execute complex SQL query directly in QlickView Script? By the term complex I mean a query containing (Count(), GroupBy, OrderBy, DATEADD() ) ....
Thank you,

Nabil

Re: running complex SQL query in QV

Anonymous — Mon, 01 Sep 2014 13:30:02 GMT

You can execute any valid SQL query you wish.

Re: running complex SQL query in QV

Mon, 01 Sep 2014 13:33:03 GMT

I've a valid one but it always failed in reading it

Re: running complex SQL query in QV

rajeshvaswani77 — Mon, 01 Sep 2014 13:35:29 GMT

The correct way would be to read the raw table as it is using select without any where clause or grouping.

At the QlikView script level apply the logic that is there in the Query.

thanks,

Rajesh Vaswani

Re: running complex SQL query in QV

Mon, 01 Sep 2014 13:45:13 GMT

Rajesh Vaswani did you mean to reproduce all the SQL function that are already in the query with the QV functions?

Re: running complex SQL query in QV

ashfaq_haseeb — Mon, 01 Sep 2014 13:48:13 GMT

Hi,

It should work as bill says.

Can you post your query here to check the issue.

Regards

ASHFAQ

Re: running complex SQL query in QV

rajeshvaswani77 — Mon, 01 Sep 2014 14:01:03 GMT

Yes, again depends on your scenario as well as the architecture you have in place.

thanks,

Rajesh Vaswani

Re: running complex SQL query in QV

Mon, 01 Sep 2014 14:06:37 GMT

This is the query ,

select DATEADD(dd, DATEDIFF(DD, 0, X.actual_end_date_time),0), tile_run_state_id, Count(*) from X
Join X_state on X.state = X_state.tile_run_state_id

Where X_state.tile_run_state_id = 5

Group by DATEADD(DD, DATEDIFF(DD, 0, X.actual_end_date_time),0), tile_run_state_id

ORDER BY DATEADD(DD, DATEDIFF(DD, 0, X.actual_end_date_time),0) DESC

the query is working normally with SQL server Management Studio but not with QV

Re: running complex SQL query in QV

rajeshvaswani77 — Mon, 01 Sep 2014 14:11:08 GMT

times out. As an alternative see if you can give a timeout value while creating the connecting string.

thanks,

Rajesh Vaswani