The QVX Library only supports select statements with the following syntax:
SQL select *fieldlist from tablelist
For more complex statement, such as
SQL select * from friends where gender = 'female' and relationship_status = 'Married';
you can do one of the following:
- Write your own query parser as described below.
- Use preceding load.
Writing your own query parser gives you more control over the loading process but requires more development. A simpler solution is to use preceding load in QlikView or Qlik Sense. This requires the script to be slightly modified.
Instead of
SQL select * from friends where gender = 'female' and relationship_status = 'Married';
use
load * where gender = 'female' and relationship_status = 'Married';
SQL select * from friends;
For more information about preceding load, please refer to the QlikView or Qlik Sense online help.