Script parsing

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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?