Qlik Community

Qlik Sense Deployment & Management

Discussion board where members learn more about Qlik Sense Installation, Deployment and Management.

zied_ahmed1
Contributor III

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
New Contributor II

Re: help scripting

Hi Zied,

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

zied_ahmed1
Contributor III

Re: help scripting

Hello i am connected to a database

Community Browser