Re: help scripting - Qlik Community

zied_ahmed1 · ‎2017-03-27

I would like to do a script like these in sql

Number of cars

SELECT * FROM Table WHERE Type = 'car' and date='17/01/01'

-- Active cars

SELECT DISTINCT (Machine) FROM Table WHERE Type= 'car ' and date='17/01/01'

any suggestions please ?

vchuprina · ‎2017-03-27

Hi Zied,

What do you want to use as data source (excel, txt, ...)?

Press LIKE if the given solution helps to solve the problem.
If it's possible please mark correct answers as "solutions" (you can mark up to 3 "solutions").

zied_ahmed1 · ‎2017-03-27

Hello i am connected to a database