topic Re: convert sql transaction to script code qlik sense in Management & Governance

convert sql transaction to script code qlik sense

zied_ahmed1 — Tue, 28 Mar 2017 11:22:11 GMT

Hello i need to calculate ratio between :

Number of cars in sql is :

SELECT * FROM table WHERE Type= 'car' and date='2017' (i need this in script as Number_cars)

Number actif cars in sql is :

SELECT DISTINCT (Machine) FROM table WHERE Type= 'car' and date='2017' ( I need this in script as Active_cars)

Thanks for help

jonathandienst — Tue, 28 Mar 2017 11:27:15 GMT

ODBC CONNECT ....

OLEDB CONNECT ....

Number_cars:

SQL SELECT * FROM table WHERE Type= 'car' and date='2017';

Active_cars:

LOAD Machine as Active_cars;

SQL SELECT DISTINCT Machine FROM table WHERE Type= 'car' and date='2017';

zied_ahmed1 — Tue, 28 Mar 2017 11:32:42 GMT

Hello Jonathan,

I already loaded previously these fields : Type and date and Machine to do some works,

no i need after that add script code like the two transactions

zied_ahmed1 — Tue, 28 Mar 2017 14:22:22 GMT

stalwar1‌ any suggestions please?