Qlik can execute SQL Select statement when you point it to database. Once data is loaded you can re-use loaded table using "Resident" statement.
Other statements which Load data are :
Load - Inline
Load - Autogenerate
Load - From (this is the one you used to load your excel)
If your task was simply to load a table from excel where employeeId <10 than you could put Where clause on "FROM" statements like this:
IF(Gender='M','Male','Female') AS [Gender],
FROM [lib://Veronica_Tables (oatpro_vcc8908)/HumanResources_Employee2.xlsx]
(ooxml, embedded labels, table is HumanResources_Employee)
Where [EmployeeID] < 10
You have to start learning from beginning. I suggest you go through this brilliant 10$ book - it covers everything from very beginning:
I understand you are working with Qlik Sense, but scripting you can learn also in QlikView. There are only small variances in connection libraries, so you should be OK. This book comes with tonnes of example and tonnes of case studies. For beginners is a 100% MUST
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.
Good morning, Mr Lech:
Thank you for pointing me into the right direction. I am using right now the book: Qlik Sense for Beginners from Mark O'Donovan. The exercise I am having trouble is form page 69. Also, using for reference QlikView your Business from Oleg Troyansky and another book Learning Qlik Sense The Official Guide 2nd ed.. I will try your recommendation and let you know.
Thank you very much for taking time to respond my question. I really appreciated.
PD English is not my first language, sorry for any grammar error.