There is no open data connection.

[LhZagora]

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:

[martinpohl]

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

[LhZagora]

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 

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;*/

[martinpohl]

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