Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I have an excel books with a lot of SQL from Microsoft ODBC Query File. I won't to convert those Queries to QVD /QV table and link to to master tables.... .
Is is any other tips/way to achieve such
SELECT
d.duration AS duration,
Call_day_duration.a_day ||' '||MAX(d.a_time) - '00:00:30'::TIME AS PCall_submit_trunc,
Call_day_duration.NB_Call
FROM
RC_DAYS_TIME d
INNER JOIN (
SELECT
PCall_submit::DATE AS A_DAY,
(EXTRACT(HOUR from PCall_submit)*3600+extract(MINUTE from PCall_submit)*60+extract(SECOND from PCall_submit)) AS duration,
COUNT(*) AS NB_Call
FROM
Call_CDR
WHERE
PCall_submit::DATE >= '2015-06-24'
and
PCall_submit::DATE <= '2015-07-23'
GROUP BY 1, 2
ORDER BY 1, 2
) AS Call_day_duration
ON d.duration = Call_day_duration.duration
GROUP BY
1,Call_day_duration.a_day ,3
ORDER BY 2 ;
I want a chart (bar) for PCall_submit_trunc as dim and Call_day_duration.NB_Call and expression
Thank you !
Sire
If you want to bring these to QlikView or QlikSense, you just need to use the following:
Table1:
LOAD
*;
SQL SELECT
d.duration AS duration,
Call_day_duration.a_day ||' '||MAX(d.a_time) - '00:00:30'::TIME AS PCall_submit_trunc,
Call_day_duration.NB_Call
FROM
RC_DAYS_TIME d
INNER JOIN (
SELECT
PCall_submit::DATE AS A_DAY,
(EXTRACT(HOUR from PCall_submit)*3600+extract(MINUTE from PCall_submit)*60+extract(SECOND from PCall_submit)) AS duration,
And the same for other SQL statement:
Table2:
LOAD
*;
SQL SELECT
COUNT(*) AS NB_Call
FROM
Call_CDR
WHERE
PCall_submit::DATE >= '2015-06-24'
and
PCall_submit::DATE <= '2015-07-23'
GROUP BY 1, 2
ORDER BY 1, 2
) AS Call_day_duration
ON d.duration = Call_day_duration.duration
GROUP BY
1,Call_day_duration.a_day ,3
ORDER BY 2 ;
As a result of this Table1 and Table2 will be joined with an outer join via NB_Call dimension.
if I understand
define the odbc connection to your db
add the sql (in your post) to qlikview script
table:
sql
select ........ // replace with all your sql
;
and reload