3 Replies Latest reply: Mar 28, 2017 10:22 AM by Zied Ahmed RSS

    convert sql transaction to script code qlik sense

    Zied Ahmed

      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