Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
zied_ahmed1
Specialist
Specialist

help scripting

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 ?

2 Replies
vchuprina
Specialist
Specialist

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
Specialist
Specialist
Author

Hello i am connected to a database