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() ) ....
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.
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