Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for Data Integration and Data Analytics gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor
Contributor

There is no open data connection.

Hello All 

Im new to qliksense 

I want to agregate data from my first table Power_Consumption_Raw whit sql request but im getting There is no open data connection error 

 

Code:

Qliksense.png

3 Replies
Highlighted
Partner
Partner

Re: There is no open data connection.

You want to load additional datas to your excel file.

Therefor you have to define where the datas are from.

on the right site there are your data connections. I only can see the connection to your data folder.

Maybe some rights are missing for you to use ODBC-data connections?

Regards

Highlighted
Contributor
Contributor

Re: There is no open data connection.

Rights like what ? 

i think probably the probably is in how Qliksense read sql query 

because i have done another simple query and it works 

 

This One work 

Qliksense.png

 

But this one doesn't work :

Data are loaded from an excel file for Power_Consumption_Raw table

 

/*Select Leg, 'Service' as Type, 'Load Less Then 0.75' as TypeLoad , sum(Service_power) as Puissance,100*count(*)/2/(Select count(*) from Power_Consumption_Raw PR2 where IFNULL(PR2.Leg, '') = IFNULL(PR.Leg, '')) as Nombre_Load from Power_Consumption_Raw
where DG_average_load <= 0.75
group by Leg
UNION ALL
SELECT Leg, 'Propulsion' as Type,'Load Less Then 0.75' as TypeLoad, sum(Propulsion_power) as Puissance, 100*count(*)/2/ (Select count(*) from Power_Consumption_Raw PR2 where IFNULL(PR2.Leg, '') = IFNULL(PR.Leg, '')) as Nombre_Load from Power_Consumption_Raw PR
where DG_average_load <= 0.75
group by Leg
UNION ALL
SELECT Leg, 'Service' as Type, 'Load BTW 0.75 AND 0.80' as TypeLoad , sum(Service_power) as Puissance, 100*count(*)/2/(Select count(*) from Power_Consumption_Raw PR2 where IFNULL(PR2.Leg, '') = IFNULL(PR.Leg, '')) as Nombre_Load from Power_Consumption_Raw PR
where DG_average_load > 0.75 AND DG_average_load <=0.8
group by Leg
UNION ALL
SELECT Leg, 'Propulsion' as Type,'Load BTW 0.75 AND 0.80' as TypeLoad, sum(Propulsion_power) as Puissance, 100*count(*)/2/(Select count(*) from Power_Consumption_Raw PR2 where IFNULL(PR2.Leg, '') = IFNULL(PR.Leg, '')) as Nombre_Load from Power_Consumption_Raw PR
where DG_average_load > 0.75 AND DG_average_load <=0.8
group by Leg

UNION ALL
SELECT Leg, 'Service' as Type, 'Load BTW 0.80 AND 0.82' as TypeLoad , sum(Service_power) as Puissance, 100*count(*)/2/(Select count(*) from Power_Consumption_Raw PR2 where IFNULL(PR2.Leg, '') = IFNULL(PR.Leg, '')) as Nombre_Load from Power_Consumption_Raw PR
where DG_average_load > 0.80 AND DG_average_load <=0.82
group by Leg
UNION ALL
SELECT Leg, 'Propulsion' as Type,'Load BTW 0.80 AND 0.82' as TypeLoad, sum(Propulsion_power) as Puissance, 100*count(*)/2/(Select count(*) from Power_Consumption_Raw PR2 where IFNULL(PR2.Leg, '') = IFNULL(PR.Leg, '')) as Nombre_Load from Power_Consumption_Raw PR
where DG_average_load > 0.80 AND DG_average_load <=0.82
group by Leg

UNION ALL
SELECT Leg, 'Service' as Type, 'Load BTW 0.82 AND 0.85' as TypeLoad , sum(Service_power) as Puissance, 100*count(*)/2/(Select count(*) from Power_Consumption_Raw PR2 where IFNULL(PR2.Leg, '') = IFNULL(PR.Leg, '')) as Nombre_Load from Power_Consumption_Raw PR
where DG_average_load > 0.82 AND DG_average_load <=0.85
group by Leg
UNION ALL
SELECT Leg, 'Propulsion' as Type,'Load BTW 0.82 AND 0.85' as TypeLoad, sum(Propulsion_power) as Puissance, 100*count(*)/2/(Select count(*) from Power_Consumption_Raw PR2 where IFNULL(PR2.Leg, '') = IFNULL(PR.Leg, '')) as Nombre_Load from Power_Consumption_Raw PR
where DG_average_load > 0.82 AND DG_average_load <=0.85
group by Leg;*/

Highlighted
Partner
Partner

Re: There is no open data connection.

in the script editor, on the right side, there are your connections.

connections to folders or to ODBC or REST or something else.

There are no database connection I can see in your screenshot.

The example that works use resident. resident is a command to load data inside the script, not from a file or a database.

regards