You can start from here Load ‒ QlikView
The opportunity of using the syntax of language SQL in Qlik scripts is limited by the capabilities of drivers SQL and is different for different drivers. In general, it is considered good practice to use language Qlik in scripts.
Hello Saurav, (thanks for tagging me and letting me aware of your question)
Additional information on getting started with QlikView can be found here:
Qlik Sense here:
In regards to your questions - it is not necessarily the case to use data load script to create advanced and exciting interactive dashboards - data load script - is used to load data into the qlik data model and there are also a variety of chart functions that are used after the data load - and these are used as expressions either in the Measure or Dimension settings of the chart object. So it greatly depends on your needs. We also have a robust set of APIs where you can create almost anything - limited to your imagination.
Here is a great example of use Qlik APIs to create a chat bot: Push the Boundaries of Analytics - Qlik Sense Bot (video)
FOR SQL - you really only need to load the base tables using simple selects - you DO NOT NEED aggregation functions, order or group functions, sub-selects - correlated sub-queries etc. At times you may want to use advanced SQL - for specific needs - perhaps to output data to a QVD (file based representation of the compressed Qlik in-memory data model used to quickly load data into a Qlik app - instead of from the source) - but for the most part it is not necessary.
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.