Video explanation here: https://www.youtube.com/watch?v=8hDJlc6p5lE

Something that I come across on a regular basis is customers asking about dates in Qlik.  Fiscal calendars, complete calendars, creating current year to date vs last year to date, and matching dates between two date fields are all things that have come up.

The answer to all of these is to create a master calendar.  That said, creating a master calendar is not always the easiest thing to do or learn from online posts.

I have attached 'Master Calendar.zip' that contains two .txt files designed to automatically create a master calendar from your data. 

In 'Master Calendar Variables.txt' you can paste the contents after your current load script in your app and fill in the variables:

- Table name that contains the date

- Whether you want to create a fiscal calendar and which month that fiscal calendar should start in

- Your Date field(s) - if you insert two date fields, it will perform an IntervalMatch

In 'Master Calendar Script.txt' you can either paste the contents below the Variables or use an Include statement  below the Variables to call on the script.

That's it!  Hope this helps!

I spent a bunch of time on and off trying to figure how to generate an email alert when a reload fails. It's something I and I'm sure many others wish was built-in and worked out-of-the-box, but it's actually somewhat possible. There are some restrictions - for me, I sometimes get reloads that hang, even though I put in a max retry, and since they don't "fail," I never get the notification. And obviously, the email notification is generalized to the point where you have to log into the QMC to discover which app failed. But if you're a Qlik Sense admin, you're smart enough how to make customized email alerts for each reload task :).

Setting up Qlik Web Connectors

1. If necessary, whitelist your Qlik Sense server’s IP in your mail relay.
2. Download the QlikWebConnectors zip folder from the Qlik support site: https://us-d.demo.qlik.com/download/ 
   1. Filter down to "Qlik Connectors" and under the "Products" section, scroll down to find "Qlik Web Connectors."
   2. Find the most recent Initial Release and click on the name to download - March 2020 at time of writing.
3. Extract that folder to the root of the C drive. Rename the folder to QlikWebConnectors if it is not already named so.
4. You may notice no installation has ran yet. We will get back to that later. If you open the QlikWebConnectors folder, you can run QlikWebConnectors.exe to start the program. A window will appear in the bottom right of your screen.
   
    

   

5. Click "open in default browser" to begin setup. Accept the license agreement.
6. While you can technically write out the script directly in a Qlik Sense app, a sanitized version of which I will provide below, the following is how to set up through the SMTP Connector.
7. There are a lot of Connectors available. Browse to the "Standard" tab and open "Qlik SMTP Connector." Highlight SendEmail and click Parameters.
8. Set up the fields according to how your mail server requires. Mine is set up to allow anonymous authentication but only whitelisted servers are allowed. Below is how mine is set up, but yours may be different.
   1. SMTP Server: FQDN of your mail relay
   2. Port: usually 25
   3. SSL Mode: depends on your setup - mine is anonymous so I set to "None"
   4. To: email you want to receive the email alerts
   5. Subject: email subject
   6. Message: email body
   7. HTML: check this box so you can use HTML tags in your Qlik script
   8. From name: display name the email is being sent from
   9. From email: email address the email is being sent from
9. Click "Save Inputs & Run Table." On success, the To Email you entered above will receive the email.
10. Click over to the "Qlik Sense (Standard Mode)" tab. You will see some instructions and some auto-generated code. Copy it to the clipboard.
    
11. Create a new Qlik Sense app titled something descriptive (e.g. "Send Email"), open the Data Load Editor, and paste the code into the Data Load Editor. You may get a warning that the app has no data, which is expected and can be safely ignored.
    
12. Follow the instructions highlighted in red to set up the Web File connection. It should look as below. Give it a descriptive name as well. Make sure you create this as the Web Connector program is still running on the Qlik server.
    
13. Make sure the variable "vQwcConnectionName" matches the name of the email connection you just created.
    
14. Click "Load Data" to test the email and make sure it gets sent to the email you set above.
    
15. The obvious quirk of this set up is it requires the WebConnector program to be running constantly. Luckily, QlikWebConnectors can be set up to run as a service.
16. On the Qlik Sense server, browse to C:\QlikWebConnectors\BatchFiles.
17. Edit "Install Service.bat" and make sure the .NET and QlikWebConnectors_SVC.exe paths are valid.
    
18. Close Notepad and run the "Install Service.bat" as an admin. When the script has completed after a few seconds, press any key to close.
    
19. Open Services.msc, find Qlik Web Connectors, and change the Log On to your Qlik service account. You may otherwise run into errors in the future if you try to re-setup any connectors.
20. Start the service.
21. Right-click, Properties, and switch to the Recovery tab. Change the "First Failure" dropdown to "Restart the service." Change "Restart service after" to zero minutes. Click Apply and OK.
    
22. If you try to run the QlikWebConnectors.exe program again, you will get an error that the program is already running.
    

Setting up Task Failure Triggers

1. Log into the QMC.
2. Browse to Tasks either from the Dashboard or the sidebar.
   
   
3. Create a new task, name it something descriptive, and select the Send Email app you created above as the app. The email sends within seconds so it is recommended to lower the default timeout and increase the retries, though this depends on your environment.
   
   
4. Click the "Actions" dropdown and select "Create new task event trigger."
   
   
5. Name the trigger task something descriptive relative to the app, click "Add Task," change the dropdown to "Task Failed," and select the task you want to be alerted on a failure of. You can leave the time constraint as the default, it is not relevant when a task chain is only two tasks long, as is the case now. More information here: https://help.qlik.com/en-US/sense/June2019/Subsystems/ManagementConsole/Content/Sense_QMC/create-reload-tasks-from-tasks.htm
   
   
6. Repeat this process for each individual task you want to be alerted on. You can add a new Send Email app per app, new trigger event per Send email app, or new task per trigger event. I recommend the second for the sake of cleanliness and succinctness.
   
   
    
7. Make sure this trigger event process is repeated for each new app that is published in the future.
8. When you go to the Tasks page in the QMC, you will notice little chain symbols for every app that is connected to the Send Email app and vice versa. You can click on this chain symbol to view the task chains from either direction.
   

Editing the Notification App

As written above, the actual script that runs the SMTP Connector is complete and already published to Qlik Sense. In other words, if you ever need to edit or re-publish the app or change the SMTP settings, there is little to do. Details below:

1. When you set up the SMTP Connector and run the parameters, you will be given the below line of Qlik script. Notice how hard-coded the (unredacted) bold parameters are.
   
2. Of course, hard-coding is not best practice and the syntax is not obvious at first glance. The bold parameters are replaced by variables in the actual published Qlik Sense app.
   
   
3. Variables, when placed in the URL script line, must be in the form of $(variablename). If you look closely, every parameter is simply "parameter1=$(variable1)&parameter2=$(variable2)&..." The parameters from the original script block are untouched while the hard-coded values are now variables.
   
   
4. The script blocks are separated into sections, marked by comment sections. To go through them one-by-one:
   1. The first section is for script neatness. vQwcConnectionName pulls the webfile defined above into the script. vTimestamp is used for the email body.
      
   2. These variables are the content that you will edit. The two "...Input" variables define the content of the email body and subject. More on them in the next section. The rest of the variables are what they sound like.
      
   3. I would strongly recommend never touching these lines. The URL script line in Qlik Sense requires plus signs in the place of spaces for each value. These two lines replace the spaces with plus signs for you so editing the value is easier.
      

[Redacted] QS Script for Send Email app

/**** you shouldn't have to modify these after setup ****/
let vQwcConnectionName = '[web file connector]';
let vTimestamp = timestamp(now());

/**** Edit these variables to change the email contents. ****/
let vMessageInput = 'Qlik Sense Task Failure at ' & '$(vTimestamp)' & '.<br><br>To Review, <a href="https://[Qlik Sense URL].com/qmc">go to the QMC.</a>';
let vSubjectInput = 'Qlik Sense Task Failure';
let vSMTPserver = ' ';
let vFromName = ' ';
let vSMTPPort = '25';
/**** use %40 in place of the @ symbol ****/
let vToEmail = '';
let vFromEmail = '';

/**** DO NOT EDIT ****/
/**** These variable text strings properly encode the text in the "input" variables ****/
/**** Replaces all spaces with plus signs in the message string above ****/
let vMessage = replace('$(vMessageInput)',' ','+');
let vSubject = replace('$(vSubjectInput)',' ','+');
/**** DO NOT EDIT ****/

SMTPConnector_SendEmail:
LOAD
    status as SendEmail_status,
    result as SendEmail_result,
    filesattached as SendEmail_filesattached
FROM [$(vQwcConnectionName)]
(URL IS [http://localhost:5555/data?connectorID=SMTPConnector&table=SendEmail&SMTPServer=$(vSMTPserver)&Port=$(vSMTPPort)&SSLmode=None&to=$(vToEmail)&subject=$(vSubject)&message=$(vMessage)&html=True&fromName=$(vFromName)&fromEmail=$(vFromEmail)&delayInSeconds=0&ignoreProxy=False&appID=], qvx);

// IMPORTANT: If, when loading the above script, you receive a 'Script Error' Dialog box with a 'Field Not Found'
// (or other) error, the first thing you should do is copy and paste the full request URL (i.e. the URL between the square [...]
// brackets IN THE QLIKVIEW / QLIK SENSE SCRIPT ERROR DIALOG) into a browser address bar and check the response.

• Tasks in a Gantt Chart (requires Google timeline extension).
• Show Task intensity.
• QVDs with all their metadata information, including fields.
• Scripts analysis (via logs) and the dependencies of your scripts for the QVDs they use. Useful to debug and see the pain points in your scripts and how much time these portions take to load).

Gantt chart of TasksTask intensityQVD info - tables and fieldsScript analysis - load time and key words searchCross table of QVD tables and fields

You will need to run a script to loop through all the Governance Dashboard table in order to store them in QVDs.

This loop is available in the "05a*. CONFIG" tab.

The tabs 05a to 05f are to analyse log files and link them back to the tasks. It then will follows the logic and data model which goes from  Task > App ( > Script) > QVD.

Set the library connection to "vQMC_QVD_Store" where the Governance Dashboard QVDs are contained.

Set the URL to the QlikSense server you are analysing in "vQlikSenseServer".

In the "Full_Paths_To_Folder" inline table, set the library paths to the folders where you generate and store your QVDs from your scripts.

Please check the script portion just above this table, as you can set times during the day when you run the QVD files analyses. The QVD analysis portion of script can take long depending on the amount of QVDs you have. The rest of the task analysis portion should take less than a minute.

In order to run the script analysis test, set "vRunLogAnalysis" to 'Yes' and set the location of the folder where the log files are contained in "vScriptLogFolder".

If you use standardised sub-routines (Calls) you can set the wildmatch-string search in the "Script_KeyWords_Categorisation_List" table.

The 05g tab will run a dependency table that will link all your tasks and apps depdendency on QVDs as written in your script logs.

If you use a windows a Active Directory UDC to import and manage users in Qlik Sense, then among other things , Qlik Sense will store the windows UserID, User Name, Directory, AD group memberships, and email address of the users inside the Qlik Sense repository. Usually the important 'domain account' of a user in NPrinting is nothing more than the Directory\UserID drawn from Qlik Sense.   Since NPrinting requires just a few more attributes of the user (default locale , timezone and a generic password which can be hard coded to default values or loaded from another source like a database or spreadsheet) , the Qlik Sense repository can be used as an effective source of users to import into NPrinting. It works especially well when the NP users are already QLIK users which occurs with on-demand use cases.

The Qlik Sense repository is accessible through the QRS REST API and the users + user attributes (including emails and groups) can be read directly through the Qlik Sense REST Connector inside the data load editor.  You can author a new REST connection or you can simply use the built in "monitor_apps_REST_user"  data connection that is setup automatically when you first install Qlik Sense.  Just note that this connection is used by the default monitoring apps and is configured by default to work only on a central node .  You need to reconfigure the data connection to work in a multinode qlik sense environment

https://help.qlik.com/en-US/sense/June2018/Subsystems/Monitoring/Content/Troubleshooting/troubleshooting-monitoring.htm

So what happens once you can read the users + attributes into a Qlik Sense load script ?

Well,  you can then use Gianluca's wonderful reference document How to use Qlik NPrinting APIs inside a Qlik Sense load script  and the attached sample to inject the same users through the same REST Connector and a data connection that points this time to the NPrinting API to create / update / delete  or in short, manage, your users in NPrinting.

Please note the 2nd half of this technique can be applied with ANY accessible Qlik source to load users into NPrinting.

Now although the technique involves script, the benefits is that the syncing can be done by simply scheduling a Qlk Sense Task and/or chaining upon success/failure of another Qlik Sense task.  So you get to operate Qlik/NPrinting through a single scheduler.

Another benefit is that using this and other reference methods you can unlock the REST API without being a REST developer because you re-use Qlik load script techniques using the out of box Qlik Sense, NPrinting and REST Connector products/components.  This untaps more automation in how you operate NPrinting with Qlik Sense and can provide more nuance than a standard featurized solution .

Sample

The technique is dependent on the foundational approach outlined in this post  https://community.qlik.com/thread/292037  .

• Components of the solution
  
             
  
  
  • A REST Connector GET connection to the NPrinting API
  • A REST Connector POST connection the NPrinting API
  • The "monitoring_apps_REST_user"  REST Connection used by the monitoring apps to connect to the QRS API
  • Qlik script with the following sections
    
    
• Setup

1. Ensure QLik Sense Feb 2018+ and NPrinting are installed and setup.
2. Import the attached app
3. Create two NPrinting REST connections .    (Refer to pages 8-11 of the document  "How to use NPrinting APIs within a Sense load script"  )     https://community.qlik.com/thread/292037
4. Record the two names of the REST connections you create and enter the NAMES of the REST Connector connections on line 29 and 30 of the 'Setup' section of the load script below
   
   
   
   
5. On line 34 , enter the name of your 'monitor_apps_REST_user'  REST connection to the QRS API. on line 34.
6. On line 38,  enter  'True' if you use https to access NPrinting or 'False' if you use http to access NPrinting
7. On lines 39 and 40, enter the server:port of the NPrinting Web Console and Qlik Sense Hub respectively
8. On line 44, enter the directory of the users you would like to sync from QLik Sense to NPrinting
   
   for example, in the Qlik Sense QMC there are multiple directories of users .  Pick the directory of users you would like to sync.

1. On lines 45 , 46, and 47 , enter 'True'  if you want to create users in NPrinting , update existing users in NPrinting, and/or  delete existing users in NPrinting
   
   create = true:    Any valid user present in the Qlik Sense repository and directory will be created in NPrinting during the sync if they don't already exist in NPrinting
   update = true:   If an NPrinting user already exists in NPrinting , update the user with the latest settings during the sync
   delete = true:    delete all users (except a named administrator) from NPrinting unless they exist in Qlik Sense
   
   
2. On line 48 and 49,  enter the current email address and name used by one adminstrator that ALREADY EXISTS in the NPrinting repository.  NPrinting requires one admin at all times. For that reason, this user will always be skipped, it won't be updated or deleted.
   
   
3. On lines 58-62 , provide default settings for the remaining required recipient attributes.  NPrinting recipients will be created with these defaults.
   
   
4. Please note that creates and updates will also update the DOMAIN ACCOUNT of the NPrinting recipient using the directory and userid properties from qlik sense.

The above solution will sync USERS from Qlik Sense to NPrinting.  A logical enhancement would be to sync GROUP memberships from Qlik Sense.  In NPrinting,  'groups' are just recipient groups that bucket recepients together for report delivery whereas

'security roles' define which capabilities and content the recipients can see. So .. .when you sync groups you could sync them to groups memberships or role memberships depending how/if you may want to leverage existing AD group memberships.

Another enhancement would be to sync and update user filters.  THis is also readily possible by loading the necessary data tables and data values into the QLik Sense app so they can be associated to users and prepped for update into the NPrinting API.

Monitoring current performance and availability of Qlik Sense site is not out-of-the-box feature, but can be easily achieved with native REST connector and requesting engine\healthcheck JSON API.

There are other tools and approaches, but since I already have the best BI tool available 😉, I found it reasonable to use it. All that is necessary is just:

1. download and import the attached app
2. create REST Data Connections and adjust the settings in the script
3. schedule app reload

This Qlik Sense app:

• loads engine\healthcheck JSON data from multiple nodes
• parses and consolidates it to two tables
• stores them to QVDs with all previous snapshots
• visualizes key metrics of engine utilization and availability in time

It's recommended to deploy and schedule this app on DEV or TEST site, pointing to all production nodes. Otherwise, there will be no data loaded in case the production engine (or the whole server) crashes.
(just FYI - DEV and TEST sites are included in the professional license subscription)

It's also recommended to read the official help site info about the engine API before you deploy this app.

After importing the app to a suitable site, follow these steps:

1. Decide on target folder for result QVD files, where parsed snapshot of JSON data will be stored. Create a folder Data Connection (if it doesn’t already exist) and set its Lib name to vQVDpath variable in Settings script section.

2. Create a REST Data Connection to each node:

URL: https://<server domain>/engine/healthcheck OR https://<node IP address>:4747/engine/healthcheck

Authentication Schema: Windows NTLM
User name & password: type root admin or service user credentials
check "Skip server certificate validation" if there is no valid certificate on target node

Query headers:
User-Agent: Windows
Cache-Control: no-cache

3. Adjust the INLINE table in the Settings section of the script according to your site

node - name of the node that will be shown for app’s user
restConnection - name of the REST connection that points to node’s engine/healthcheck
RAM - amount of node's memory in GB
CPU - number of node's logical processors

4. Schedule a reload task. The recommended app reload frequency is 5 minutes or less (tested reload duration on the 4-node site is 12 seconds). The script will return "N/A" in [isSaturated] field when the engine is not responding.

The current roadmap includes - script for email notifications, possibility to load only N days back, mapping app name to IDs, node comparisons.

PLEASE! If you make adjustments or additions to the script or front-end visualizations, please share them back on the Qlik Community.

Happy Qliking 🙂
-RADO-

This example was worked out using Qlik Sense Desktop 1.1.0

Thank you to Christof Schwarz for this solution.

For this example, the dimension is "Segment" and the measures are "Sales", "Quota", and "Expenses".  The requirement is a bar chart with Sales in green, Quota in blue, and Expenses in red.

Normally with a Qlik Sense bar chart, I would have one dimension: Segment, and three measures: Sum(Sales), Sum(Quota), and Sum(Expenses).  However, for custom colors, I need to have two dimensions and one measure.  The second dimension and the one measure are using the ValueList() function.

See attached qvf file "BarChartColorByMeasure.qvf".  It has two sheets.  Both sheets have a bar chart displaying the same information.  The first shows coloring without customizing.  The second sheet shows customized coloring.

Here's what I did.  I made a bar chart...

First dimension:

Field: Segment

Label: Segment

Added a second dimension:

Field: ValueList('Sales','Quota','Expenses')

Label: Account Type

Added a measure:

Field:

if(ValueList('Sales','Quota','Expenses')='Sales'

  ,Sum(Sales)

  ,if(ValueList('Sales','Quota','Expenses')='Quota'

     ,Sum(Quota)

     ,Sum(Expenses)

     )

  )

Label: Amount

Sorting in this example is by Segment then by Account Type then by Amount, with Account Type as descending alphabetical.

Now to set the colors.  I went to "Appearance" then "Colors and Legend", then turned off Auto for Colors.  In the dropdown, selected "By expression".  I entered this expression:

if(ValueList('Sales','Quota','Expenses')='Sales'

  ,rgb(0,192,0)

  ,if(ValueList('Sales','Quota','Expenses')='Quota'

     ,rgb(0,0,192)

     ,rgb(192,0,0)

     )

  )

I made sure the check box was checked for "The expression is a color code".

Please note: You will not able to show the chart's legend.  This is a known limitation.  For right now in Qlik Sense, the color legend is not displayed when using "The expression is a color code".

When utilizing QlikSense, Sheet Level Security can be achieved through Security Rules via the QMC.

Background:

My suggested approach to implementing Sheet Level Security is to create four new Security Rules after disabling the default rules.  It involves a User Directory with properties for the Company, Application, and Sheets.  Custom properties in the QMC will need to be created to contain the same User Directory property values.

Custom properties are created, in the QMC, and assigned to the individual Applications and Streams.  This allows for a general approach to handling an expanding list of Companies and their various Applications.  As the number of Applications and Companies grow, the User Directory Properties and Custom Properties will both need to be updated to grant access to the new applications and the application's sheets.

**Note** Please disable the default rules, please do not delete them.

Security Rule to Disable is the Stream rule...

Rule Name = Stream

Resource Filter = App*

In the example below, I am utilizing a user directory that has user properties.  It identifies an individual directory to apply the security rules to.  If you have multiple user directories, you will need to include them in the rule or create seperate rules for them.

Create four new rules for Streams, Applications, Sheets, and Non-Sheet Application Objects.

1) Rule for Streams

1. Filter = Stream_*
2. Suggested Logic = Identify a group of QlikSense Users who meet the criteria to access the stream.
   1. Users must below in an identified User Directory
   2. Users must have the user property of Company that matches the Custom Property (Company) assigned to the stream

((

user.userDirectory="Specific User Group"

and user.company=resource.@Company

))

2) Rule for Applications

1. Filter = App_*
2. Suggested Logic = Identify a group of QlikSense Users who meet the criteria to access the applications.
   1. Users must have the user property of Company that matches the Custom Property (Company) assigned to the application.
   2. Users must have the user property of applications that matches the Custom Property (Applications) assigned to the application
   3. User must have Read Permission to the stream the application is in
      

((

resource.resourcetype = "App"

and user.userDirectory="Specific User Group"

and user.company=resource.@Company

and user.applications=resource.@Applications

and resource.stream.HasPrivilege("read")

))

3) Rule for Sheets

1. Filter = App.Object_*
2. Suggested Logic = Identify a group of QlikSense Users who meet the criteria to access the sheets.
   1. The Object must be a sheet
   2. The Users must have the user property of sheets that matches the Sheet Name
      

((

user.userDirectory="Specific User Group"

and resource.objectType="sheet"

and user.sheets=resource.name

))

4) Rule for Non-Sheet Application Objects

1. Filter = App.Object_*
2. Suggested Logic = Identify a group of QlikSense Users who meet the criteria to access the other application objects.
   1. The Object Must not be a sheet (Explicitly exclude sheet to ensure Rule above will work)
   2. The Objects you want the user to access must be included in the 'or' section
   3. Excluding an Object Type will exclude access
   4. Using the 'resource.objectType!=' will also exclude Application Object
      

((

user.userDirectory="Specific User Group"

and resource.objectType!="sheet"

and resource.objectType="bookmark"

or resource.objectType="appprops"

or resource.objectType="bookmark"

or resource.objectType="dimension"

or resource.objectType="embeddedsnapshot"

or resource.objectType="GenericVariableEntry"

or resource.objectType="listbox"

or resource.objectType="masterobject"

or resource.objectType="measure"

or resource.objectType="snapshot"

or resource.objectType="story"

))

I like mathematics and see the potential it is not only in robotics or “almost sci-fi” technologies but everywhere where data is generated and should be understood.

I like Qlik, its possibilities and simplicity for end-users at the same time.

However, when it comes to mathematics and Qlik together, a lot of people think about SSEs – python or R – and default Qlik math functions are underestimated. I think there might be two reasons – Qlik users do not know about them or do not understand when these functions can help them. So, I decided to develop a Qlik app that will get you an overview of default mathematical functions in Qlik with a little bit of theory and above all, examples and exercises. All of them are interactive – thanks to Qlik 😉.

In the QS Math & Statistics app v3.0 you can find:

• Quiz to test your skills with Qlikculator I am very proud of 😄 (what to do for 5 hours in a train without wifi)
• An interactive overview of basic math functions with examples
• Descriptive statistics – theory, example, and my thoughts:
  • Measures of central tendency
  • Measures of variability
  • Percentiles, quartiles, fractiles
  • Measures of distribution
  • Overview of different datasets
• Intro to correlation
• Financial functions
  • Overview with the Payment calculator
  • Future Value & Present Value

If you will find the app useful, in next versions I will add:

• Outliers & extreme values – why and how to identify them
• Financial aggregation functions (IRR, NPV, XIRR, XNPV)
• Linear regression with examples not only for prediction
• Combinatorics examples
• Statistical distribution functions

Thanks, @radoresky  for your help and review of the app 

I hope you will like it. Any recommendations are very welcome 😉,

Maria

Attached is a sub-routine that will automatically create a fully-automated incremental (change-data-capture/CDC) SalesForce extractor for Qlik.

Sub-routine QVS file downloadable here. (Hi Qlik Discussion Boards Team: one can upload almost all file types but not a QVS or TXT?)

The SOQL query will fetch all the fields in the underlying table and requires only 4 parameters:

1. the LIB connection to your target root folder for storing your QVDs (it will automatically create an "SFDC" sub-folder under this root;
2. the Salesforce table name and
3. the primary-key field in that table (typically, the "Id" field).
4. the datetime stamp for the incremental load (typically, either LastModifiedDate or CreatedDate).

Sample of script:

//Below is the attached sub-routine file you need to INCLUDE
$(Must_Include=lib://QVDATA-USER_SBI_QlikSense/SFDC/SFDC_FullyAutomatedIncrementalLoad.qvs);

LIB CONNECT TO 'Salesforce';

LET vRootFolder = 'lib://QlikSense/QVData';

//Below are the CALLs for the sub-routine in the above QVS file
CALL SFDC_FullyAutomatedIncrementalLoad('$(vRootFolder)','CaseHistory','Id','CreatedDate');
CALL SFDC_FullyAutomatedIncrementalLoad('$(vRootFolder)','Contact','Id','LastModifiedDate');

The script does 2 things.
Firstly, it fetches the last "+2 days" (as a buffer) of data using the SOQL "LAST_N_DAYS" function between the last known "datetime stamp for the incremental load" and TODAY() for that SFDC table (the script generates a QVD file in a "_Delta" folder with the "datetime stamp for the incremental load" for that table) and puts this in a "SFDC_[SalesForceTableName]" sub-folder by "datetime stamp for the incremental load" YYYYMM.
Secondly, it runs through the whole set of QVDs in the "SFDC_[SalesForceTableName]" sub-folder, loads them reverse-chronologically with a "WHERE NOT EXISTS on the Primary-Key" so that you only end up with Id-record for the last known modified date (not duplicates or the QVD 'history' of that record). It then writes this QVD (ready for consumption in an Qlik analytical app) in the root "../SFDC" folder.

The first run of this script might take longer to run as it creates the underlying QVD structure, loading ALL the data from the SFDC table.
Thereafter it will run 'incrementally'.

Have fun. If you have thoughts or comments, please post.

C  ;o)

Hi Folks,

This document helps to give idea about fetch the Statistics data from YouTube based on Rest API.

Before starting on Qliksense, we need to create our own YouTube API Key via https://console.developers.google.com/project

Once API Key is created, we can use the URL like below in Rest API:

https://www.googleapis.com/youtube/v3/videos?part=snippet%2CcontentDetails%2Cstatistics&key={YourAPIKey}&id={YoutubeId}

Rest App URL:

Once the connection is successful. We can select the required information via select data

Sample Data

Sample Query:

LIB CONNECT TO 'YouTube API';

RestConnectorMasterTable:
SQL SELECT
"kind" AS "kind_u0",
"etag" AS "etag_u0",
"__KEY_root",
(SELECT
"id",
"__KEY_items",
"__FK_items",
(SELECT
"publishedAt",
"channelId",
"title" AS "title_u0",
"description" AS "description_u0",
"channelTitle",
"__KEY_snippet",
"__FK_snippet",
(SELECT
"__KEY_thumbnails",
"__FK_thumbnails"
FROM "thumbnails" PK "__KEY_thumbnails" FK "__FK_thumbnails")
FROM "snippet" PK "__KEY_snippet" FK "__FK_snippet"),
(SELECT
"__KEY_contentDetails",
"__FK_contentDetails"
FROM "contentDetails" PK "__KEY_contentDetails" FK "__FK_contentDetails"),
(SELECT
"viewCount",
"likeCount",
"dislikeCount",
"favoriteCount",
"commentCount",
"__FK_statistics"
FROM "statistics" FK "__FK_statistics")
FROM "items" PK "__KEY_items" FK "__FK_items")
FROM JSON (wrap on) "root" PK "__KEY_root" WITH CONNECTION (

QUERY "id" "$(vIDs)");

[snippet]:
LOAD [publishedAt],
[channelId],
[title_u0] AS [title_u0],
[description_u0] AS [description_u0],
[channelTitle],
[__KEY_snippet],
[__FK_snippet] AS [__KEY_items]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_snippet]);

[statistics]:
LOAD [viewCount],
[likeCount],
[dislikeCount],
[favoriteCount],
[commentCount],
[__FK_statistics] AS [__KEY_items]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_statistics]);

[items]:
LOAD [id],
[__KEY_items]
RESIDENT RestConnectorMasterTable
WHERE NOT IsNull([__FK_items]);

DROP TABLE RestConnectorMasterTable;

For Dynamic / Multiple YouTube videos, we can achieve with help of "With Connection" like highlighted.

WITH CONNECTION (

QUERY "id" "$(vIDs)");

Here vIDs is the variables stores multiple youtube ids with comma separated. 

Final Output looks like

Result

Regards,

Mayil Vahanan R

For those of you that love to get exact specification of Qlik's syntax - a BNF diagram would be nice to have.

Here is the BNF that Qlik Sense and QlikView use in their QIX engine when reading and interpreting load scripts and in running applications when evaluating Expressions including Set Expressions:

(******************************************************************************)

(* QlikView Script Syntax                                                    *)

(******************************************************************************)

(* File Layout:                                                              *)

(* Part 1: Miscelanious Helper Rules                                          *)

(* Part 2: Expression Helper Rules                                            *)

(* Part 3: Statement Rules And Statement Specific Helper Rules                *)

(* Part 4: Direct Discovery                                                  *)

(* Part 5: Prefix Rules                                                      *)

(* Part 6: Control Statement Rules                                            *)

(* Part 7: Derived Statement Rules                                            *)

(*                                                                            *)

(*                                                                            *)

(* Everything is in logical or Alphabetical order within each part            *)

(*                                                                            *)

(* In or statement, put the longest cases first so that the parsing dont stop *)

(* at the first but shortest match.                                          *)

(*                                                                            *)

(* BNF Syntax                                                                *)

(*    All words are rules                                                    *)

(*    '  '  Literal strings enclosed in single quotes                        *)

(*    ( | )  Parenthesis mark the start and end of an OR statement            *)

(*    [  ]  Optional                                                        *)

(*    {  }  Zero or more repitions                                          *)

(*    <  >  All or nothing, the content is fully matched or not at all      *)

(*          A function name must be followed by a '(' or its not a f-name    *)

(*    X-Y  token match X but NOT Y                                          *)

(*                                                                            *)

(*                                                                            *)

(*                                                                            *)

(*    ?Statement?  The Rule is a script statement                            *)

(*    ?Control?    The Rule is a control statement                          *)

(*    ?ControlMiddle=X? Control Line as part of X rule                        *)

(*    ?ControlEnd=X?    Control Line marking end of X rule                    *)

(*    ?func?        The rule is a function                                    *)

(*    ?aggr?        The rule is an aggregation function                      *)

(*    ?field?      The rule is a field name                                  *)

(*    ?Name?                                                                  *)

(*    ?RetType?                                                              *)

(*    ?deprecated?  The rule or syntax is deprecated and might be removed    *)

(*                  in the future. Use new alternative instead                *)

(*    ?secret?      The content in the rule is secret and must not be put in  *)

(*                  logfiles and progress dialogs                            *)

(*    ?product?    ?product=sense? or ?product=qlikview?                    *)

(*                  By default a rule is available to all products            *)

(*                  Only applicable to rules (before definiation ('=')        *)

(*                                                                            *)

(*                                                                            *)

(* Some rules, like function names are added at runtime                      *)

(*                                                                            *)

(*                                                                            *)

(*  TDOD TODO                                                                *)

(* GRAND is replaced with ALL a long time ago, but accepted for legacy        *)

(* reasons. These are equivalent with the Set-expression {1} so a            *)

(* SET-expression cant be combined with ALL (or GRAND).                      *)

(*                                                                            *)

(*                                                                            *)

(******************************************************************************)

(******************************************************************************)

(******************************************************************************)

(* Part 1: Miscelanious Helper Rules                                          *)

(******************************************************************************)

(******************************************************************************)

RawText = {SCANNER_TOKEN_MATCH_ANYTHING};

SecretRawText = ?secret? {SCANNER_TOKEN_MATCH_ANYTHING};

AnonymousRawText = {SCANNER_TOKEN_MATCH_ANYTHING};

AnyString = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD );

AnyStringOrAnySymbol = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD | SCANNER_TOKEN_MATCH_ANYTHING);

AnyStringOrNumber = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD | LITERAL_NUMBER);

TableName = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD | LITERAL_NUMBER);

FieldName = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD );

FieldNumber = LITERAL_NUMBER;

    AliasFieldName = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD );

FieldNameOrStar = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD | '*' );

AllFieldStar = '*';

FileName =  ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD );

CompositeFileName = CompositeFileNamePart { CompositeFileNamePart };

CompositeFileNamePart = (

                (* Realy need to use a nicer definition *)

                WHITESPACE | LITERAL_NUMBER | IDENTIFIER | LITERAL_STRING | LITERAL_FIELD |

                OPERATOR_PLUS | OPERATOR_MINUS | OPERATOR_MULTIPLICATION | OPERATOR_DIVISION |

                OPERATOR_STRING_CONCAT |

                OPERATOR_LESS | OPERATOR_LESS_EQUAL | OPERATOR_GREATER | OPERATOR_GREATER_EQUAL | OPERATOR_EQUAL | OPERATOR_NOT_EQUAL |

                OPERATOR_RIGHT_SHIFT | OPERATOR_LEFT_SHIFT | OPERATOR_COLON_COLON |

                SYNTAX_RIGHT_PAREN | SYNTAX_COMMA | SYNTAX_COLON | SYNTAX_EXCLAMATION | SYNTAX_TILDE |

                OPERATOR_PLUS_EQUAL | OPERATOR_MINUS_EQUAL | OPERATOR_MULT_EQUAL | OPERATOR_EQUAL_EQUAL | OPERATOR_DIV_EQUAL

                );

                (* Everything but SYNTAX_SEMI_COLON  SYNTAX_LEFT_PAREN  COMMENT *)

                (* Eat all tokens until '(', used in many places in QV script *)

VariableName = ( IDENTIFIER - ControlWords | LITERAL_STRING - ControlWords | LITERAL_FIELD - ControlWords );

    ControlWords = ( 'Call' | 'Case' | 'Do' | 'Elseif' | 'For' | 'If' | 'Next' | 'Sub' | 'Switch' );

SecretAnyString ?secret? = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD );

(******************************************************************************)

(******************************************************************************)

(* Part 2: Expression Helper Rules                                            *)

(******************************************************************************)

(******************************************************************************)

StringOperatorLike = 'like';

LogicalOperatorNot = 'not';

LogicalOperatorAnd = 'and';

LogicalOperatorOr = 'or';

LogicalOperatorXor = 'xor';

RelationalOpertorFollows = 'follows';

RelationalOpertorPrecedes = 'precedes';

BitOperatorNot = 'bitnot';

BitOperatorAnd = 'bitand';

BitOperatorOr =  'bitor';

BitOperatorXor = 'bitxor';

ExpressionConstant = ( LITERAL_NUMBER | LITERAL_STRING );

ExpressionFieldRef = ( LITERAL_FIELD | IDENTIFIER );

ExpressionFieldRefFixFormat = < IDENTIFIER ':' > (IDENTIFIER|LITERAL_NUMBER) [('T' | 'N' | 'R' | 'I' | 'U' | 'B' )];

ExpressionUnaryOperator = ( OPERATOR_PLUS | OPERATOR_MINUS | LogicalOperatorNot | BitOperatorNot );

ExpressionBinaryOperator = (OPERATOR_PLUS | OPERATOR_MINUS | OPERATOR_MULTIPLICATION | OPERATOR_DIVISION |

                            OPERATOR_STRING_CONCAT | StringOperatorLike |

                            LogicalOperatorAnd | LogicalOperatorOr | LogicalOperatorXor |

                            OPERATOR_LESS | OPERATOR_LESS_EQUAL | OPERATOR_GREATER | OPERATOR_GREATER_EQUAL | OPERATOR_EQUAL | OPERATOR_NOT_EQUAL |

                                RelationalOpertorFollows |  RelationalOpertorPrecedes |

                            BitOperatorAnd | BitOperatorOr | BitOperatorXor | OPERATOR_RIGHT_SHIFT | OPERATOR_LEFT_SHIFT );

UnaryExpression = (  ExpressionFunctionCall |

                ModuleFunctionCall |

                <ExpressionUnaryOperator Expression> |

                ExpressionConstant |

                ExpressionFieldRef |

                ExpressionFieldRefFixFormat |

                '(' Expression ')'

                );

Expression =  UnaryExpression [ExpressionBinaryOperator Expression];

(******************************************************************************)

(******************************************************************************)

(* Part 3: Statement Rules And Statement Specific Helper Rules                *)

(******************************************************************************)

(******************************************************************************)

AliasStatement = {DefaultPrefix} ?Statement?'Alias' AliasStatementRename {',' AliasStatementRename};

    AliasStatementRename = FieldName 'as' AliasFieldName;

BinaryStatement = {DefaultPrefix} ?Statement? 'Binary' RawText;

CommentStatement = {DefaultPrefix} ?Statement? 'Comment' [('Tables' | 'Table' | 'Fields' | 'Field' )] ( CommentUsing | CommentWith );

    CommentUsing = 'Using' TableName;

    CommentWith = TableName 'With' AnyString;

(* Ancient CONNECT statement did not require 'TO'                *)

(* But in that case we did not support access info.              *)

(* That never worked with custom connects                        *)

CustomConnectStatement = {DefaultPrefix} ( ?Statement? ?deprecated? 'CustomConnect' | 'CUSTOM'  ?Statement? 'Connect')  'To' CustomConnectString;

    (* CustomConnectString = SCANNER_TOKEN_MATCH_ANYTHING { SCANNER_TOKEN_MATCH_ANYTHING }; *)

    CustomConnectString = SecretAnyString;

LibConnectStatement = {DefaultPrefix} 'LIB' ?Statement? 'Connect' 'To' LibConnectString;

ServiceConnectStatement = {DefaultPrefix} 'Service' ?Statement? 'Connect' 'To' ConnectString;

ConnectPrefix = ( 'ODBC' | 'OLEDB' ); (* OLEDB is default if there is no ConnectPrefix *)

Connect64Statement = {DefaultPrefix} [ConnectPrefix] ?Statement? 'Connect64' 'To' ConnectString [AccessInfo];

Connect32Statement = {DefaultPrefix} [ConnectPrefix] ?Statement? 'Connect32' 'To' ConnectString [AccessInfo];

ConnectStatement =  {DefaultPrefix} [ConnectPrefix] ?Statement? 'Connect' 'To' ConnectString [AccessInfo];

    (*  ConnectString ?secret? = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD ); *)

    (* ConnectString ?secret? = CompositeFileNamePart { CompositeFileNamePart }; *)

    ConnectString = SecretAnyString;

    LibConnectString = AnyString;

    AccessInfo = '(' AccessItem { ',' AccessItem} ')';

        AccessItem = (AccessItemAutoCommit | AccessItemCodePage | AccessItemMode | AccessItemPassword |

                      AccessItemSSO | AccessItemUserID | AccessItemXPassword | AccessItemXUserID );

            AccessItemUserID = 'UserID' 'is' SecretAnyString;

            AccessItemXUserID = 'XUserID' 'is' SecretAnyString;

            AccessItemPassword = 'Password' 'is' SecretAnyString;

            AccessItemXPassword = 'XPassword' 'is' SecretAnyString;

            AccessItemMode = 'mode' 'is' 'write';

            AccessItemAutoCommit = 'AutoCommit' ( '0' | 'off'); (* only AutoCommit was perviosly allowed, but ignored *)

            AccessItemCodePage = 'CodePage' 'is' ('off' | 'ansi' | 'unicode' | 'oem' | LITERAL_NUMBER);

            AccessItemSSO = 'SSO';

DirectoryStatement = {DefaultPrefix} ?Statement? 'Directory' RawText;

DisConnectStatement = {DefaultPrefix} ?Statement? 'DisConnect';

DropFieldStatement = {DefaultPrefix} ?Statement? 'Drop' ('Field'|'Fields') FieldName {',' FieldName} ['From' TableName {',' TableName} ];

DropTableStatement = {DefaultPrefix} ?Statement? 'Drop' ('Table'|'Tables') TableName {',' TableName};

ExecuteStatement = {DefaultPrefix} ?Statement? 'Execute' AnonymousRawText;

FlushLogStatement = {DefaultPrefix} ?Statement?  'FlushLog';

ForceStatement = {DefaultPrefix} ?Statement? 'force' ( 'capitalization' | 'case' ( 'upper' | 'lower' | 'mixed' ) );

InputFieldStatement ?product=qlikview? = {DefaultPrefix} ?Statement? 'InputField' FieldName {',' FieldName}; (* obsolete in sense *)

LetStatement = {DefaultPrefix} ?Statement? 'Let' VariableName '=' [Expression];

LoadStatement = {LoadPrefixOrLabel} ?Statement? 'Load' ['Distinct'] FieldList [LoadSource];

    FieldList = FieldListFieldOrStar {',' FieldListFieldOrStar };

        FieldListFieldOrStar =  ( '*' | Field );

        Field = ( FieldRef | Expression ) [ 'as' FieldRefAlias];

            FieldRef = ( IDENTIFIER | LITERAL_FIELD );

            FieldRefAlias = ( IDENTIFIER | LITERAL_FIELD | LITERAL_NUMBER | LITERAL_STRING );

    LoadSource = ( LoadSourceCommon | LoadSourceResident | LoadSourceExtension | LoadFollowing );

        LoadFollowing = [LoadClauses];

        LoadSourceCommon = (LoadAutoGenerate | LoadFrom | LoadFromField | LoadInline ) [FileFormatSpec]  [LoadClauses];

            LoadFrom = 'From' CompositeFileName;

            LoadInline = 'Inline' InlineData;

                InlineData = (LITERAL_STRING | LITERAL_FIELD);

            LoadFromField = 'From_Field' '('TableName ',' FieldName ')';

            LoadAutoGenerate = 'AutoGenerate' Expression;

        LoadSourceResident = LoadResident [LoadClauses] [FileOrderBy];

            LoadResident = 'Resident' ResidentTableLabel;

                ResidentTableLabel = TableName;

        LoadSourceExtension = 'Extension' ExtensionFunction '(' [ ExtensionParams ] ')';

            ExtensionFunction = IDENTIFIER '.' IDENTIFIER;

            ExtensionParams = ( ExtensionScript [ ',' ExtensionSourceTableSpec ] | ExtensionSourceTableSpec );

            ExtensionScript = LITERAL_STRING;

            ExtensionSourceTableSpec = TableName [ '{' ExtensionFieldList '}' ];

              ExtensionFieldList = ExtensionFieldOrStar {',' ExtensionFieldOrStar };

                  ExtensionFieldOrStar = ( '*' | ExtensionField );

                      ExtensionField = (ExtensionFieldRef | ExtensionStringFieldRef | ExtensionMixedFieldRef) [ 'as' FieldRefAlias];

                          ExtensionFieldRef = FieldRef;

                          ExtensionStringFieldRef = 'String' '(' FieldRef ')';

                          ExtensionMixedFieldRef = 'Mixed' '(' FieldRef ')';

    FileFormatSpec = '(' FileFormatSpecItem {',' FileFormatSpecItem } ')';

        FileFormatSpecItem = ( FileType | FileCp | FileLabel | FileQuote | FileDelimiter | FileNoEof | FileTableIs |

                              FileHeaderIs | FileRecordIs | FileCommentIs | FileTabIs | FileFilter | FileInternetURLIs | FileInternetUserAgentIs );

            FileType = ( 'biff' | 'dif' | 'fix' | 'html' | 'json' | 'kml' | 'ooxml' | 'qvd' | 'qvx' | 'txt' | 'xml' | 'xmlGeneric' | 'xmlSax' | 'xmlSimple' );

            FileCp = ( FileCpName | FileCpGeneric);

                FileCpName = ('ansi' | 'oem' | 'mac' | 'utf8' | 'utf7' | 'symbol' | 'unicode');

                FileCpGeneric = 'codepage' 'is' LITERAL_NUMBER;

            FileLabel = ( 'embedded' | 'explicit' | 'no' ) 'labels';

            FileQuote = ( 'msq' | 'no' 'quotes' );

            FileDelimiter = 'delimiter' 'is' ( 'spaces' | IDENTIFIER | LITERAL_NUMBER | LITERAL_STRING | SYNTAX_COLON );

                (* Use quoted literals for delimiter. Colon specifically added because its common *)

                (* Delimiter is a single ascii character, or an escape sequence like: \\, \t, \r, \b, \n, \0octal, \xHex  *)

            FileNoEof = 'no' 'eof';

            FileTableIs = 'Table' 'is' TableName;

            FileHeaderIs = 'Header' 'is' ( FileRecordSingleLine | FileRecordBytes | FileRecordManyLines );

            FileRecordIs = 'Record' 'is' ( FileRecordSingleLine | FileRecordBytes | FileRecordManyLines );

                FileRecordSingleLine = LineKeyword;

                FileRecordBytes = LITERAL_NUMBER;

                FileRecordManyLines = LITERAL_NUMBER LineKeyword;

                    LineKeyword = ( 'line' | 'lines' );

            FileCommentIs = 'Comment' 'is' AnyString;

            FileTabIs = 'tab' 'is' LITERAL_NUMBER;

            FileFilter = ?deprecated? 'filters' '(' FileFilterItem {',' FileFilterItem} ')' ;

                FileFilterItem = ( FileFilterItemColSplit |

                                  FileFilterItemColumnExtract |

                                  FileFilterItemExpand |

                                  FileFilterItemInterpret |

                                  FileFilterItemRemove |

                                  FileFilterItemReplace |

                                  FileFilterItemRotate |

                                  FileFilterItemHeaderRename |

                                  FileFilterItemTranspose |

                                  FileFilterItemUnwrap );

                    FileFilterItemReplace = 'Replace' '(' FileFilterItemReplaceColumn ',' FileFilterItemReplaceFromDirection ',' FileFilterStringCond ')';

                        FileFilterItemReplaceColumn = LITERAL_NUMBER;

                        FileFilterItemReplaceFromDirection = ('top' | 'bottom' | 'right' | 'left' );

                    FileFilterItemRemove = 'Remove' '(' ('Row'|'Col') ',' (FileFilterRowCond | FileFilterTableIndex) ')';

                    FileFilterItemHeaderRename = 'Top' '(' LITERAL_NUMBER ',' AnyString ')';

                    FileFilterItemInterpret = 'Interpret' '(' LITERAL_NUMBER ','  AnyString  ',' AnyString ','  LITERAL_NUMBER  ')';

                    FileFilterItemUnwrap = 'Unwrap' '(' ('Row'|'Col') ','  (FileFilterTableIndex |FileFilterRowCond) ')';

                    FileFilterItemRotate = 'Rotate' '(' ('left'|'right')  ')';

                    FileFilterItemColumnExtract = 'ColXtr' '(' LITERAL_NUMBER ',' FileFilterRowCond ',' LITERAL_NUMBER  ')';

                    FileFilterItemTranspose = 'Transpose' '(' ')';

                    FileFilterItemExpand = 'Expand' '(' LITERAL_NUMBER ',' AnyString ',' LITERAL_NUMBER [',' FileFilterRowCond ]  ')' ;

                    FileFilterItemColSplit = 'ColSplit' '(' LITERAL_NUMBER ','  FileFilterIntArray ')';

                                    FileFilterStringCond = 'StrCnd' '(' ('null' |

                                                                        'equal' ',' AnyString |

                                                                        'contain' ',' AnyString |

                                                                        'start' ',' AnyString |

                                                                        'end' ',' AnyString |

                                                                        'length' ',' LITERAL_NUMBER |

                                                                        'shorter' ',' LITERAL_NUMBER| (* Acually means strings longer than x !. 'Buggy' name !  *)

                                                                        'longer' ',' LITERAL_NUMBER | (* Acually means strings shorter than x ! 'Buggy' name ! *)

                                                                        'numerical') [FileFilterStringCondOptionList] ')' ;

                                        FileFilterStringCondOptionList = {',' FileFilterStringCondOption };

                                            FileFilterStringCondOption = ( 'not' | 'case' );

                                    FileFilterTableIndex = 'Pos' '(' ('Top'|'Bottom') ','  LITERAL_NUMBER ')';

                                    FileFilterSelectPattern = 'Select' '(' LITERAL_NUMBER ',' LITERAL_NUMBER ')';

                                    FileFilterRowCond = (FileFilterRowCondCompound | FileFilterRowCondSimple );

                                        FileFilterRowCondCompound = 'RowCnd' '(' 'Compound' ',' FileFilterRowCondSimple {',' FileFilterRowCondSimple} ')';

                                        FileFilterRowCondSimple = ( FileFilterRowCondCellValue | FileFilterRowCondInterval | FileFilterRowCondColMatch | FileFilterRowCondEvery );

                                            FileFilterRowCondCellValue = 'RowCnd' '(' 'CellValue' ',' LITERAL_NUMBER ',' FileFilterStringCond ')';

                                            FileFilterRowCondInterval = 'RowCnd' '('  'Interval' ',' FileFilterTableIndex ',' FileFilterTableIndex ',' FileFilterSelectPattern ')';

                                            FileFilterRowCondColMatch = 'RowCnd' '('  'ColMatch' ')';

                                            FileFilterRowCondEvery = 'RowCnd' '('  'Every' ')';

                                    FileFilterIntArray = 'IntArray' '(' [ LITERAL_NUMBER {',' LITERAL_NUMBER} ] ')';

            FileInternetURLIs = 'URL' 'is' AnyString;

            FileInternetUserAgentIs = 'UserAgent' 'is' AnyString;

    LoadClauses = [(FileWhere | FileWhile)] [FileGroupBy];

    FileWhere = 'Where' Expression;

    FileWhile = 'While' Expression;

    FileGroupBy = 'Group' 'By' Expression {',' Expression};

    FileOrderBy = 'Order' 'By' FileOrderByFieldAscDesc {',' FileOrderByFieldAscDesc };

        FileOrderByFieldAscDesc = (FieldName|FieldNumber) [('asc'|'desc')];

LoosenTableStatement = {DefaultPrefix} ?Statement? 'Loosen' ('Table'|'Tables') TableName {',' TableName};

MapUsingStatement = {MapUsingPrefix} ?Statement? 'Map' MapUsingFieldList 'using' MapUsingMapName;

    MapUsingFieldList = (FieldNameOrStar {',' FieldNameOrStar} );

    MapUsingMapName = AnyString;

NullAsValueStatement = {DefaultPrefix} ?Statement? 'NullAsValue' FieldNameOrStar {',' FieldNameOrStar};

NullAsNullStatement = {DefaultPrefix} ?Statement? 'NullAsNull' FieldNameOrStar {',' FieldNameOrStar};

QualifyStatement = {DefaultPrefix} ?Statement? 'Qualify' FieldNameOrStar {',' FieldNameOrStar};

UnqualifyStatement = {DefaultPrefix} ?Statement? 'Unqualify' FieldNameOrStar {',' FieldNameOrStar};

RemStatement = ?Statement? 'Rem' SecretRawText;

RenameFieldStatement = {DefaultPrefix} ?Statement? 'Rename' ('Field'|'Fields') ('using' TableName | RenameFieldRename {',' RenameFieldRename});

    RenameFieldRename = FieldName 'to' FieldName;

RenameTableStatement = {DefaultPrefix} ?Statement? 'Rename' ('Table'|'Tables') ('using' TableName | RenameTableRename {',' RenameTableRename});

    RenameTableRename = TableName 'to' TableName;

SectionStatement = ?Statement? 'Section' SectionType;

    SectionType = ( 'Access' | 'Application' );

SelectStatement = {SelectPrefixOrLabel} ?Statement? 'Select' AnonymousRawText;

SetStatement = {DefaultPrefix} ?Statement? 'Set' VariableName '=' [RawText];

SleepStatement = {DefaultPrefix} ?Statement? 'Sleep' Expression;

SqlStatement = {SelectPrefixOrLabel} ?Statement? 'SQL' AnonymousRawText;

SqlColumnsStatement = {DefaultPrefix} ?Statement? 'SQLColumns';

SqlTablesStatement = {DefaultPrefix} ?Statement? 'SQLTables';

SqlTypesStatement = {DefaultPrefix} ?Statement? 'SQLTypes';

StarStatement = {DefaultPrefix} ?Statement? 'Star' 'is' [AnyStringOrAnySymbol];

StoreStatement = {DefaultPrefix} ?Statement? 'Store' [<StoreFieldList 'from'>] TableName 'into' CompositeFileName [StoreFormatSpec];

    StoreFormatSpec = '(' StoreFormatSpecItem {',' StoreFormatSpecItem } ')';

        StoreFormatSpecItem = ( StoreFileType | FileDelimiter  );

            StoreFileType = ('qvd' | 'txt' | 'qvx');

    StoreFieldList = StorFieldListFieldOrStar {',' StorFieldListFieldOrStar };

        StorFieldListFieldOrStar =  ( '*' | StoreField );

        StoreField = StoreFieldRef [ 'as' StoreFieldRefAlias];

            StoreFieldRef = ( IDENTIFIER | LITERAL_FIELD | LITERAL_STRING );

            StoreFieldRefAlias = ( IDENTIFIER | LITERAL_FIELD | LITERAL_NUMBER | LITERAL_STRING );

TagStatement = {DefaultPrefix} ?Statement? 'Tag' TagSecondPart;

UntagStatement = {DefaultPrefix} ?Statement? 'Untag' TagSecondPart;

    TagSecondPart =  [('Fields' | 'Field' )] ( TagUsingTable | TagFieldWith );

        TagUsingTable = 'Using' TableName;

        TagFieldWith = FieldName {',' FieldName} 'With' AnyString {',' AnyString};

TraceStatement = {DefaultPrefix} ?Statement? 'Trace' RawText;

UnmapStatement = {DefaultPrefix} ?Statement? 'Unmap' (AllFieldStar | FieldName {',' FieldName} );

SearchStatement = {DefaultPrefix} ?Statement? 'Search' ('Include' | 'Exclude' ) FieldNameOrStar {',' FieldNameOrStar};

(******************************************************************************)

(******************************************************************************)

(* Part 4: Direct Discovery                                                  *)

(******************************************************************************)

(******************************************************************************)

(* Direct Discovery 2.0 *)

DD_KeyWords = ( 'and' | 'as' | 'cross' | 'detach' | 'detail' | 'dimension' | 'distinct' | 'external' |

                'false' | 'from' | 'full' | 'in' | 'inner' | 'is' | 'join' | 'left' | 'like' | 'measure' |

                'native' | 'natural' | 'not' | 'null' | 'on' | 'or' | 'right' | 'true' | 'using' | 'where' );

DD_SimpleIdentifier = IDENTIFIER - DD_KeyWords;

DD_QuotedIdentifier = LITERAL_FIELD;

DD_Name = ( DD_SimpleIdentifier | DD_QuotedIdentifier );

DD_AliasName = < ( DD_NativeExpression | DD_ValueExpression ) 'as' DD_Name >;

DD_QualifiedName = ( DD_TightQualifiedName | DD_FreeStyleQualifiedName );

    DD_TightQualifiedName = DD_TightName { < '.' DD_TightName > };

        DD_TightName = LITERAL_FIELD;

    DD_FreeStyleQualifiedName = DD_Name { < ['.'] DD_FreeStyleName > };

        DD_FreeStyleName = ( DD_Name | LITERAL_NUMBER ); (* '.E' in '.Employees' becomes a numeric literal + 'mployees' *)

DD_QuotedString = LITERAL_STRING;

DD_NumericLiteral = LITERAL_NUMBER;

DD_SpecialLiteral = ( 'false' | 'null' | 'true' );

DD_LiteralValue = ( DD_NumericLiteral | DD_QuotedString | DD_SpecialLiteral );

DD_VariableSubstitution = '{' DD_SimpleIdentifier '}';

DD_DirectQueryStatement = {TableLabel} ?Statement? 'DIRECT' 'QUERY' DD_ColumnClauses DD_FromClause { DD_JoinClause } [DD_WhereClause];

DD_FromClause = 'FROM' DD_QualifiedName;

DD_ColumnClauses = DD_ColumnClause {DD_ColumnClause};

    DD_ColumnClause = DD_ColumnType DD_FieldList;

        DD_ColumnType = ( 'detach' | 'detail' | 'dimension' | 'external' | 'measure' );

        DD_FieldList = DD_DerivedColumn { ',' DD_DerivedColumn };

            DD_DerivedColumn = ( DD_AliasName | DD_QualifiedName );

DD_JoinClause = ( DD_ImplicitJoinClause | DD_CrossJoinClause | DD_InnerJoinClause | DD_EquiJoinClause | DD_NaturalJoinClause | DD_OuterJoinClause );

    DD_ImplicitJoinClause = < ',' DD_QualifiedName >;

    DD_CrossJoinClause = < 'CROSS' 'JOIN' DD_QualifiedName >;

    DD_InnerJoinClause = < [ 'INNER' ] 'JOIN' DD_QualifiedName 'ON' DD_ValueExpression >;

    DD_EquiJoinClause = < 'JOIN' DD_QualifiedName 'USING' DD_NameList >;

        DD_NameList = '(' DD_Name { ',' DD_Name } ')';

    DD_NaturalJoinClause = < 'NATURAL' 'JOIN' DD_QualifiedName >;

    DD_OuterJoinClause = < ( 'FULL' | 'LEFT' | 'RIGHT' ) ['OUTER'] 'JOIN' DD_QualifiedName 'ON' DD_ValueExpression >;

DD_WhereClause = 'WHERE' ( DD_ValueExpression | DD_NativeExpression );

DD_NativeExpression = 'NATIVE' '(' DD_QuotedString ')';

DD_ValueExpression = DD_ValueTerm [ DD_ValueExpressionTail ];

    DD_ValueTerm = ( DD_FunctionCall |

                    DD_QualifiedName |

                    DD_UnaryExpression |

                    DD_LiteralValue |

                    DD_ParenthesizedExpression |

                    DD_VariableSubstitution );

DD_FunctionCallArguments = DD_ValueExpression {',' DD_ValueExpression };

DD_FunctionCall = < DD_SimpleIdentifier '(' > [ (DD_FunctionCallArgumentStar | DD_FunctionCallArguments ) ] ')';

    DD_FunctionCallArgumentStar = '*';

DD_ExpressionList = '(' DD_FunctionCallArguments ')';

    DD_UnaryExpression = DD_UnaryOp DD_ValueExpression;

    DD_ParenthesizedExpression = '(' DD_ValueExpression ')';

    DD_UnaryOp = ( '+' | '-' | 'NOT' );

    DD_ValueExpressionTail = ( DD_BinaryOpClause  | DD_InOpClause );

        DD_BinaryOpClause =  DD_BinaryOp DD_ValueExpression;

        DD_InOpClause = DD_InOp DD_ExpressionList;

    DD_InOp = 'in';

    DD_BinaryOp = ( '%' | '*' | '+' | '-' |  '/' | '<' | '<=' | '<>' | '=' | '>' | '>=' | '||' |

                    'and' | 'is'  | 'like'| 'or' );

(******************************************************************************)

(******************************************************************************)

(* Part 5: Prefix Rules                                                      *)

(******************************************************************************)

(******************************************************************************)

(*************************    Compound Prefix Rules    ************************)

TableLabel = <TableName ':'>;

(* Old qv versions allowed the table label to be defined anywhere, allow but *)

(* dont encourage. Its much easier to analyze the script if the label is a    *)

(* prefix to the actual LOAD or SELECT statement *)

MisplacedTableLabel = ?deprecated? TableLabel;

LoadPrefixOrLabel = ( TableLabel | LoadPrefix  );

LoadPrefix = (  AddPrefix | BufferPrefix | ConcatenatePrefix | CrossTablePrefix | FirstPrefix |

                GenericPrefix | HierarchyPrefix | HierarchyBelongsToPrefix | InfoPrefix |

                InnerPrefix | IntervalMatchPrefix | JoinPrefix | KeepPrefix | LeftPrefix |

                MappingPrefix | NoConcatenatePrefix | OuterJoinPrefix | ReplacePrefix | RightPrefix |

                SamplePrefix | SemanticPrefix | WhenOrUnlessPrefix);

SelectPrefixOrLabel = ( TableLabel | SelectPrefix );

SelectPrefix = ( AddPrefix | BufferPrefix | ConcatenatePrefix | CrossTablePrefix  | FirstPrefix |

                GenericPrefix | HierarchyPrefix | HierarchyBelongsToPrefix | InfoPrefix |

                InnerPrefix | IntervalMatchPrefix | JoinPrefix | KeepPrefix | LeftPrefix |

                MappingPrefix | NoConcatenatePrefix | OuterJoinPrefix | ReplacePrefix |

                RightPrefix | SamplePrefix | SemanticPrefix | WhenOrUnlessPrefix);

MapUsingPrefix = ( AddPrefix | ReplacePrefix | WhenOrUnlessPrefix );

DefaultPrefix = ( WhenOrUnlessPrefix | MisplacedTableLabel );

(*************************    Individual Prefix Rules    ************************)

AddPrefix = 'Add' ['Only'];

BufferPrefix = 'Buffer' [ '(' BufferPrefixOption[ ',' BufferPrefixOption]  ')' ];

    BufferPrefixOption = ( BufferPrefixOptionIncremental | BufferPrefixOptionStale );

        BufferPrefixOptionStale = 'Stale' ['After'] LITERAL_NUMBER [ ('day'|'days'|'hour'|'hours') ];

        BufferPrefixOptionIncremental = ( 'Incremental' | ?deprecated? 'Inc' | ?deprecated? 'Incr' );

ConcatenatePrefix = 'Concatenate' ['(' TableName ')'];

CrossTablePrefix = 'CrossTable' '(' AttributeField ',' DataField [',' QualifierFields ] ')';

    AttributeField = FieldName;

    DataField = FieldName;

    QualifierFields = LITERAL_NUMBER;

FirstPrefix = 'First' Expression;

GenericPrefix = 'Generic';

HierarchyPrefix = 'Hierarchy' '(' NodeId ',' ParentId ',' NodeName

                                  [',' [ParentName]

                                  [',' [PathSource]

                                  [',' [PathName]

                                  [',' [PathDelimiter]

                                  [',' [HierarchyDepth]

                                  ] ] ] ] ]    ')';

    NodeId = FieldName;

    ParentId = FieldName;

    NodeName = FieldName;

    ParentName = FieldName;

    PathSource = FieldName;

    PathName = AnyString;

    PathDelimiter = AnyString;

    HierarchyDepth = AnyString;

HierarchyBelongsToPrefix = 'HierarchyBelongsTo' '(' NodeId ',' ParentId ',' NodeName ',' AncestorId ',' AncestorName [',' DepthDiff] ')';

    AncestorId = AnyString;

    AncestorName = AnyString;

    DepthDiff = AnyString;

InfoPrefix = ('Bundle' ['Info'] | 'Info' ) [BundleImageSpec];

    BundleImageSpec = 'Image_Size' '(' ImageWidth ',' ImageHeight ')';

        ImageWidth = LITERAL_NUMBER;

        ImageHeight = LITERAL_NUMBER;

JoinOrKeep = ( 'Join' | 'Keep' );

InnerPrefix = 'Inner' JoinOrKeep ['('TableName')'];

IntervalMatchPrefix = 'IntervalMatch' '(' MatchField {',' KeyField } ')';

    MatchField = FieldName;

    KeyField = FieldName;

JoinPrefix = 'Join' ['(' TableName')'];

KeepPrefix = 'Keep' ['(' TableName')'];

LeftPrefix = 'Left' JoinOrKeep ['(' TableName')'];

MappingPrefix = 'Mapping';

NoConcatenatePrefix = 'NoConcatenate';

OuterJoinPrefix = 'Outer' 'Join' ['(' TableName ')'];

ReplacePrefix = 'Replace' ['Only'];

RightPrefix = 'Right' JoinOrKeep ['(' TableName ')'];

SamplePrefix = 'Sample' Expression;

SemanticPrefix = 'Semantic';

WhenOrUnlessPrefix = ('when'|'unless') Expression;

(******************************************************************************)

(******************************************************************************)

(* Part 6: Control Statement Rules                                            *)

(******************************************************************************)

(******************************************************************************)

WhenOrUnlessExpression = ('when'|'unless') Expression;

CallControl =  ?Control? 'Call' IDENTIFIER [CallParamList];

    CallParamList = '(' CallParamListItem {',' CallParamListItem }  ')';

        CallParamListItem = ( UnquotedVariableNameForCall | Expression );

            UnquotedVariableNameForCall = ( IDENTIFIER | LITERAL_NUMBER) ;

            (* Old behaviour: Unquoted tokens are variable names (including numbers) *)

DoControl = ?ControlBegin? 'Do' [ ('while' | 'until') Expression];

    ExitDoControl = ?ControlMiddle=DoControl? 'Exit' 'Do' [WhenOrUnlessExpression];

    LoopControl = ?ControlEnd=DoControl? 'Loop' [ ('while' | 'until') Expression];

ExitScriptControl = ?Control? 'Exit' 'Script' [WhenOrUnlessExpression];

ForControl = ?ControlBegin? 'For' ( ForToControl | ForEachControl);

    ForToControl = VariableName '=' Expression 'to' Expression ['step' Expression];

    ForEachControl = 'Each' VariableName 'in' ForEachList;

        ForEachList = ( ForEachDir | ForEachFile | ForEachExpression | ForEachFieldValue  );

            ForEachFile = 'FileList' '(' Expression ')' ;

            ForEachDir = 'DirList' '(' Expression ')' ;

            ForEachFieldValue = 'FieldValueList' '(' Expression ')' ;

            ForEachExpression = Expression {',' Expression };

    ExitForControl = ?ControlMiddle=ForControl? 'Exit' 'For' [WhenOrUnlessExpression];

    ForNextControl = ?ControlEnd=ForControl? 'Next' [VariableName];

IfControl = ?ControlBegin? 'If' Expression 'then';

    ElseIfControl = ?ControlMiddle=IfControl? 'ElseIf' Expression 'then';

    ElseControl = ?ControlMiddle=IfControl? 'Else';

    EndIfControl = (?ControlEnd=IfControl? 'End' 'If' | ?Control? 'EndIf');

LetControl ?Control? = <VariableName '='> [Expression];

SubControl = ?ControlBegin? 'Sub' IDENTIFIER ['(' SubParamName {',' SubParamName} ')'];

    EndSubControl = (?ControlEnd=SubControl? ?Control? 'End' 'Sub' | ?Control? 'EndSub' );

    ExitSubControl =  ?ControlMiddle=SubControl? 'Exit' 'Sub' [WhenOrUnlessExpression];

        SubParamName = IDENTIFIER;

SwitchControl = ?ControlBegin? 'Switch' Expression;

    SwitchCaseControl = ?ControlMiddle=SwitchControl? 'Case' Expression {',' Expression};

    SwitchDefaultControl = ?ControlMiddle=SwitchControl? 'Default';

    SwitchEndControl = (?ControlEnd=SwitchControl? 'End' 'Switch' | ?Control? 'EndSwitch' );

(******************************************************************************)

(******************************************************************************)

(* Part 7: Derived Statement Rules                                            *)

(******************************************************************************)

(******************************************************************************)

DefinitionStatement = DefinitionLabel ?Statement? ?product=sense? 'Declare' [('Field' | 'Fields')] 'Definition' (DefinitionSetupClause | DefinitionUsingClause );

    DefinitionLabel = <DefinitionName ':'>;

        DefinitionName = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD | LITERAL_NUMBER);

    DefinitionSetupClause = [PrefixedTagList] [DefinitionParameters] DefinitionFields [DefinitionGroups];

        PrefixedTagList = 'Tagged' TagList;

            TagList = (AnyString | ParantesisStringList);

                ParantesisStringList = '(' AnyString {',' AnyString} ')';

        DefinitionParameters = 'Parameters' DefinitionParameterAssignments;

            DefinitionParameterAssignments = DefinitionParameterAssignment {',' DefinitionParameterAssignment};

                DefinitionParameterAssignment = DefinitionParameterName '=' DefinitionParameterValue;

                    DefinitionParameterValue = ( AnyStringOrNumber | UnaryParameter );

                        UnaryParameter = OPERATOR_MINUS LITERAL_NUMBER;

                    DefinitionParameterName = AnyString;

        DefinitionFields = 'Fields' DefinitionField {',' DefinitionField};

            DefinitionField = DefinitionFieldExpression 'As' DefinitionFieldName [ PrefixedTagList ];

                DefinitionFieldExpression =  DefinitionUnaryExpression [ExpressionBinaryOperator DefinitionFieldExpression];

                    DefinitionUnaryExpression = (  ExpressionFunctionCall |

                                                    ModuleFunctionCall |

                                                    <ExpressionUnaryOperator DefinitionFieldExpression> |

                                                    ExpressionConstant |

                                                    DefinitionExpressionFieldRef |

                                                    DefinitionParameterName |

                                                    ExpressionFieldRef |

                                                    '(' DefinitionFieldExpression ')'

                                                    );

                        DefinitionExpressionFieldRef = '$' LITERAL_NUMBER;

                DefinitionFieldName = AnyStringOrNumber;

        DefinitionGroups = 'Groups' DefinitionGroup {',' DefinitionGroup};

            DefinitionGroup = DefinitionGroupFieldNames 'Type' DefinitionGroupType 'As' DefinitionGroupName;

                DefinitionGroupFieldNames = SimpleStringList;

                    SimpleStringList = AnyString {',' AnyString};

                DefinitionGroupType = ( 'drilldown' | 'collection' );

                DefinitionGroupName = AnyString;

    DefinitionUsingClause = 'Using' DefinitionName ['With' DefinitionParameterAssignments];

DeriveFieldStatement =  ?product=sense? ?Statement? 'Derive' [('Field' | 'Fields')] DeriveFromClause DeriveUsingClause;

    DeriveFromClause = 'From' ( DeriveExplicitClause | DeriveImplicitClause | DeriveFieldClause );

        DeriveFieldClause = [('Field' | 'Fields')] DeriveFieldList;

            DeriveFieldList = SimpleStringList;

        DeriveExplicitClause = 'Explicit' [('Tag' | 'Tags')] TagList;

        DeriveImplicitClause = 'Implicit' [('Tag' | 'Tags')];

    DeriveUsingClause = 'Using' DefinitionName;

(******************************************************************************)

(* QlikView Expression Syntax                                                *)

(******************************************************************************)

(* An extended subset of the script syntax file                              *)

(*                                                                            *)

(* Things like function, field, macro and bookmark names are added at runtime *)

(*                                                                            *)

(******************************************************************************)

RawText = {SCANNER_TOKEN_MATCH_ANYTHING};

AnyString = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD );

AnyStringOrNumber = ( IDENTIFIER | LITERAL_STRING | LITERAL_FIELD | LITERAL_NUMBER);

StringOperatorLike = 'like';

LogicalOperatorNot = 'not';

LogicalOperatorAnd = 'and';

LogicalOperatorOr = 'or';

LogicalOperatorXor = 'xor';

RelationalOpertorFollows = 'follows';

RelationalOpertorPrecedes = 'precedes';

BitOperatorNot = 'bitnot';

BitOperatorAnd = 'bitand';

BitOperatorOr =  'bitor';

BitOperatorXor = 'bitxor';

ExpressionConstant = ( LITERAL_NUMBER | LITERAL_STRING );

ExpressionFieldRef = FieldName;

ExpressionFieldRefFixFormat = < IDENTIFIER ':' > (IDENTIFIER|LITERAL_NUMBER) [('T' | 'N' | 'R' | 'I' | 'U' | 'B' )];

ExpressionUnaryOperator = ( OPERATOR_PLUS | OPERATOR_MINUS | LogicalOperatorNot | BitOperatorNot );

ExpressionBinaryOperator = (OPERATOR_PLUS | OPERATOR_MINUS | OPERATOR_MULTIPLICATION | OPERATOR_DIVISION |

                            OPERATOR_STRING_CONCAT | StringOperatorLike |

                            LogicalOperatorAnd | LogicalOperatorOr | LogicalOperatorXor |

                            OPERATOR_LESS | OPERATOR_LESS_EQUAL | OPERATOR_GREATER | OPERATOR_GREATER_EQUAL | OPERATOR_EQUAL | OPERATOR_NOT_EQUAL |

                                RelationalOpertorFollows |  RelationalOpertorPrecedes |

                            BitOperatorAnd | BitOperatorOr | BitOperatorXor | OPERATOR_RIGHT_SHIFT | OPERATOR_LEFT_SHIFT );

UnaryExpression = (  ExpressionFunctionCall |

                ModuleFunctionCall |

                <ExpressionUnaryOperator Expression> |

                ExpressionConstant |

                ExpressionFieldRef |

                ExpressionFieldRefFixFormat |

                '(' Expression ')' |

                ExpressionLabel |

                DefinedVariableName

                );

Expression =  UnaryExpression [ExpressionBinaryOperator Expression];

Sort-type-NUMERIC = 'NUMERIC' ',' ('ASCENDING' | 'DESCENDING' | 'REVERSE');Sort-type-TEXT = 'TEXT' ',' ('ASCENDING' | 'A2Z' | 'DESCENDING' | 'REVERSE' | 'Z2A');Sort-type-FREQUENCY = 'FREQUENCY' ',' ('ASCENDING' | 'DESCENDING' | 'REVERSE');Sort-type-LOAD_ORDER  = 'LOAD_ORDER' ',' ('ASCENDING' | 'DESCENDING' | 'REVERSE' | 'ORIGINAL');Sort-type = (Sort-type-NUMERIC | Sort-type-TEXT | Sort-type-FREQUENCY | Sort-type-LOAD_ORDER);

StructuredParameter = (Sort-type | Expression | '(' StructuredParameter {',' StructuredParameter} ')');

SetExpression = '{'SetEntityExpression  '}';

    SetEntityExpression = UnarySetEntityExpression [SetOperator SetEntityExpression];

        UnarySetEntityExpression = ( SetEntity | '(' SetEntityExpression ')'  );

    (* SetEntity = [SetIdentifier] [SetModifier]; *)

    SetEntity = ( SetIdentifier [SetModifier] | SetModifier );

        SetIdentifier = ('0' | '1' | Dog '::' | Cat '::' | Dog '::' Cat '::');

            Cat = ('$' | SetIdentfierBack | SetIdentfierNext | BookmarkId | BookmarkName );

            SetIdentfierBack = ('$1'  | '$2'  | '$3'  | '$4'  | '$5'  );

            SetIdentfierNext = ('$_1' | '$_2' | '$_3' | '$_4' | '$_5' );

    SetOperator = ( '+' | '-' | '*' | '/' );

    SetModifier = '<' FieldSelection {',' FieldSelection} '>';

        FieldSelection = FieldName [ ('=' | '+=' | '-=' | '*=' | '/=')] [ElementSetExpression];

    ElementSetExpression = ElementSet { SetOperator ElementSet } ;

        ElementSet = ( StateQualifiedFieldName | '{' [ElementList] '}' | ElementFunction );

            ElementList = Element {',' Element};

            ElementFunction = ( 'P'|'E') '(' ([SetExpression] [FieldName] | StateQualifiedFieldName) ')';

                Element  = ( ElementFieldValue | ElementSearchMask );

                    ElementFieldValue = AnyStringOrNumber;

                    ElementSearchMask = AnyString;

                StateQualifiedFieldName = (Dog '::' | Cat '::' | Dog '::' Cat '::' | '::') FieldName;

ExpressionEntry = ['='] Expression;

TextOnlyEntry = RawText;

ExpressionFunctionCall = (acos_Func |

          AddMonths_Func |

          AddYears_Func |

          Age_Func |

          Alt_Func |

          ApplyCodepage_Func |

          ApplyMap_Func |

          ARGB_Func |

          asin_Func |

          atan_Func |

          atan2_Func |

          Attribute_Func |

          Author_Func |

          AutoNumber_Func |

          AutoNumberHash128_Func |

          AutoNumberHash256_Func |

          Avg_Func |

          BitCount_Func |

          Black_Func |

          BlackAndSchole_Func |

          Blue_Func |

          Brown_Func |

          Capitalize_Func |

          Ceil_Func |

          Chi2Test_chi2_Func |

          Chi2Test_df_Func |

          Chi2Test_p_Func |

          CHIDIST_Func |

          CHIINV_Func |

          Chr_Func |

          Class_Func |

          ClientPlatform_Func |

          Color_Func |

          ColorMapHue_Func |

          ColorMapJet_Func |

          ColorMix1_Func |

          ColorMix2_Func |

          Combin_Func |

          ComputerName_Func |

          Concat_Func |

          ConnectString_Func |

          ConvertToLocalTime_Func |

          Correl_Func |

          cos_Func |

          cosh_Func |

          Count_Func |

          Cyan_Func |

          DarkGray_Func |

          Date_Func |

          Date#_Func |

          Day_Func |

          DayEnd_Func |

          DaylightSaving_Func |

          DayName_Func |

          DayNumberOfQuarter_Func |

          DayNumberOfYear_Func |

          DayStart_Func |

          Div_Func |

          DocumentName_Func |

          DocumentPath_Func |

          DocumentTitle_Func |

          Dual_Func |

          e_Func |

          Evaluate_Func |

          Even_Func |

          Exists_Func |

          exp_Func |

          fabs_Func |

          Fact_Func |

          False_Func |

          FDIST_Func |

          FieldElemNo_Func |

          FieldIndex_Func |

          FieldName_Func |

          FieldNumber_Func |

          FieldValue_Func |

          FieldValueCount_Func |

          FileBaseName_Func |

          FileDir_Func |

          FileExtension_Func |

          FileName_Func |

          FilePath_Func |

          FileSize_Func |

          FileTime_Func |

          FindOneOf_Func |

          FINV_Func |

          FirstSortedValue_Func |

          FirstValue_Func |

          FirstWorkDate_Func |

          Floor_Func |

          fmod_Func |

          Frac_Func |

          Fractile_Func |

          FV_Func |

          GetCollationLocale_Func |

          GetDataModelHash_Func |

          GetExtendedProperty_Func |

          GetFolderPath_Func |

          GetObjectField_Func |

          GetRegistryString_Func |

          GMT_Func |

          Green_Func |

          Hash128_Func |

          Hash160_Func |

          Hash256_Func |

          Hour_Func |

          HSL_Func |

          If_Func |

          InDay_Func |

          InDayToTime_Func |

          Index_Func |

          InLunarWeek_Func |

          InLunarWeekToDate_Func |

          InMonth_Func |

          InMonths_Func |

          InMonthsToDate_Func |

          InMonthToDate_Func |

          Input_Func |

          InputAvg_Func |

          InputSum_Func |

          InQuarter_Func |

          InQuarterToDate_Func |

          Interval_Func |

          Interval#_Func |

          InWeek_Func |

          InWeekToDate_Func |

          InYear_Func |

          InYearToDate_Func |

          IRR_Func |

          IsNull_Func |

          IsNum_Func |

          IsPartialReload_Func |

          IsText_Func |

          IterNo_Func |

          KeepChar_Func |

          Kurtosis_Func |

          LastValue_Func |

          LastWorkDate_Func |

          Left_Func |

          Len_Func |

          LevenshteinDist_Func |

          LightBlue_Func |

          LightCyan_Func |

          LightGray_Func |

          LightGreen_Func |

          LightMagenta_Func |

          LightRed_Func |

          LINEST_B_Func |

          LINEST_DF_Func |

          LINEST_F_Func |

          LINEST_M_Func |

          LINEST_R2_Func |

          LINEST_SEB_Func |

          LINEST_SEM_Func |

          LINEST_SEY_Func |

          LINEST_SSREG_Func |

          LINEST_SSRESID_Func |

          LocalTime_Func |

          log_Func |

          log10_Func |

          Lookup_Func |

          Lower_Func |

          LTrim_Func |

          LunarWeekEnd_Func |

          LunarWeekName_Func |

          LunarWeekStart_Func |

          Magenta_Func |

          MakeDate_Func |

          MakeTime_Func |

          MakeWeekDate_Func |

          MapSubString_Func |

          Match_Func |

          Max_Func |

          MaxString_Func |

          Median_Func |

          Mid_Func |

          Min_Func |

          MinString_Func |

          Minute_Func |

          MissingCount_Func |

          MixMatch_Func |

          Mod_Func |

          Mode_Func |

          Money_Func |

          Money#_Func |

          Month_Func |

          MonthEnd_Func |

          MonthName_Func |

          MonthsEnd_Func |

          MonthsName_Func |

          MonthsStart_Func |

          MonthStart_Func |

          MsgBox_Func |

          NetWorkDays_Func |

          NoOfFields_Func |

          NoOfReports_Func |

          NoOfRows_Func |

          NoOfTables_Func |

          NORMDIST_Func |

          NORMINV_Func |

          Now_Func |

          nPer_Func |

          NPV_Func |

          Null_Func |

          NullCount_Func |

          Num_Func |

          Num#_Func |

          NumAvg_Func |

          NumCount_Func |

          NumericCount_Func |

          NumMax_Func |

          NumMin_Func |

          NumSum_Func |

          Odd_Func |

          Only_Func |

          Ord_Func |

          OSUser_Func |

          Peek_Func |

          Permut_Func |

          Pi_Func |

          Pick_Func |

          Pmt_Func |

          pow_Func |

          Previous_Func |

          ProductVersion_Func |

          PurgeChar_Func |

          PV_Func |

          QlikTechBlue_Func |

          QlikTechGray_Func |

          QlikViewVersion_Func |

          QuarterEnd_Func |

          QuarterName_Func |

          QuarterStart_Func |

          QvdCreateTime_Func |

          QvdFieldName_Func |

          QvdNoOfFields_Func |

          QvdNoOfRecords_Func |

          QvdTableName_Func |

          QVUser_Func |

          Rand_Func |

          RangeAvg_Func |

          RangeCorrel_Func |

          RangeCount_Func |

          RangeFractile_Func |

          RangeIRR_Func |

          RangeKurtosis_Func |

          RangeMax_Func |

          RangeMaxString_Func |

          RangeMin_Func |

          RangeMinString_Func |

          RangeMissingCount_Func |

          RangeMode_Func |

          RangeNPV_Func |

          RangeNullCount_Func |

          RangeNumericCount_Func |

          RangeOnly_Func |

          RangeSkew_Func |

          RangeStdev_Func |

          RangeSum_Func |

          RangeTextCount_Func |

          RangeXIRR_Func |

          RangeXNPV_Func |

          Rate_Func |

          RecNo_Func |

          Red_Func |

          ReloadTime_Func |

          Repeat_Func |

          Replace_Func |

          ReportComment_Func |

          ReportId_Func |

          ReportName_Func |

          ReportNumber_Func |

          RGB_Func |

          Right_Func |

          Round_Func |

          RowNo_Func |

          RTrim_Func |

          Second_Func |

          SetDateYear_Func |

          SetDateYearMonth_Func |

          Sign_Func |

          sin_Func |

          sinh_Func |

          Skew_Func |

          sqr_Func |

          sqrt_Func |

          Stdev_Func |

          Sterr_Func |

          STEYX_Func |

          SubField_Func |

          SubStringCount_Func |

          Sum_Func |

          SysColor_Func |

          TableName_Func |

          TableNumber_Func |

          tan_Func |

          tanh_Func |

          TDIST_Func |

          Text_Func |

          TextBetween_Func |

          TextCount_Func |

          Time_Func |

          Time#_Func |

          Timestamp_Func |

          Timestamp#_Func |

          TimeZone_Func |

          TINV_Func |

          Today_Func |

          Trim_Func |

          True_Func |

          TTest1_conf_Func |

          TTest1_df_Func |

          TTest1_dif_Func |

          TTest1_lower_Func |

          TTest1_sig_Func |

          TTest1_sterr_Func |

          TTest1_t_Func |

          TTest1_upper_Func |

          TTest1w_conf_Func |

          TTest1w_df_Func |

          TTest1w_dif_Func |

          TTest1w_lower_Func |

          TTest1w_sig_Func |

          TTest1w_sterr_Func |

          TTest1w_t_Func |

          TTest1w_upper_Func |

          TTest_conf_Func |

          TTest_df_Func |

          TTest_dif_Func |

          TTest_lower_Func |

          TTest_sig_Func |

          TTest_sterr_Func |

          TTest_t_Func |

          TTest_upper_Func |

          TTestw_conf_Func |

          TTestw_df_Func |

          TTestw_dif_Func |

          TTestw_lower_Func |

          TTestw_sig_Func |

          TTestw_sterr_Func |

          TTestw_t_Func |

          TTestw_upper_Func |

          Upper_Func |

          UTC_Func |

          Week_Func |

          WeekDay_Func |

          WeekEnd_Func |

          WeekName_Func |

          WeekStart_Func |

          WeekYear_Func |

          White_Func |

          WildMatch_Func |

          XIRR_Func |

          XNPV_Func |

          Year_Func |

          Year2Date_Func |

          YearEnd_Func |

          YearName_Func |

          YearStart_Func |

          YearToDate_Func |

          Yellow_Func |

          ZTest_conf_Func |

          ZTest_dif_Func |

          ZTest_lower_Func |

          ZTest_sig_Func |

          ZTest_sterr_Func |

          ZTest_upper_Func |

          ZTest_z_Func |

          ZTestw_conf_Func |

          ZTestw_dif_Func |

          ZTestw_lower_Func |

          ZTestw_sig_Func |

          ZTestw_sterr_Func |

          ZTestw_upper_Func |

          ZTestw_z_Func

);

Pi_Func= ?RetType=num? ?func? < ?FuncGroup=MATH?  ?helpid=45057? 'Pi'  '(' >  ')';

Null_Func= ?RetType=dual? ?func? < ?FuncGroup=MATH?  ?helpid=45059? 'Null'  '(' >  ')';

e_Func= ?RetType=num? ?func? < ?FuncGroup=MATH?  ?helpid=45061? 'e'  '(' >  ')';

True_Func= ?RetType=num? ?func? < ?FuncGroup=MATH?  ?helpid=45063? 'True'  '(' >  ')';

False_Func= ?RetType=num? ?func? < ?FuncGroup=MATH?  ?helpid=45065? 'False'  '(' >  ')';

DaylightSaving_Func= ?RetType=num? ?func? < ?FuncGroup=DATE?  ?helpid=45067? 'DaylightSaving'  '(' >  ')';

TimeZone_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45069? 'TimeZone'  '(' >  ')';

Rand_Func= ?RetType=num? ?func? < ?FuncGroup=MATH?  ?helpid=45071? 'Rand'  '(' >  ')';

pow_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG?  ?helpid=45073? 'pow'  '(' > ?Name=x? Expression ',' ?Name=y? Expression ')';

atan2_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG?  ?helpid=45075? 'atan2'  '(' > ?Name=y? Expression ',' ?Name=x? Expression ')';

fmod_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45077? 'fmod'  '(' > ?Name=a? Expression ',' ?Name=b? Expression ')';

acos_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG?  ?helpid=45079? 'acos'  '(' > ?Name=x? Expression ')';

asin_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG?  ?helpid=45081? 'asin'  '(' > ?Name=x? Expression ')';

atan_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG?  ?helpid=45083? 'atan'  '(' > ?Name=x? Expression ')';

cos_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG?  ?helpid=45085? 'cos'  '(' > ?Name=x? Expression ')';

cosh_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG?  ?helpid=45087? 'cosh'  '(' > ?Name=x? Expression ')';

exp_Func= ?RetType=num? ?func? < ?FuncGroup=EXP?  ?helpid=45089? 'exp'  '(' > ?Name=x? Expression ')';

fabs_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45091? 'fabs'  '(' > ?Name=x? Expression ')';

Floor_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45093? 'Floor'  '(' > ?Name=x? Expression[ ',' ?Name=step? Expression[ ',' ?Name=offset? Expression]] ')';

Ceil_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45095? 'Ceil'  '(' > ?Name=x? Expression[ ',' ?Name=step? Expression[ ',' ?Name=offset? Expression]] ')';

Round_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45097? 'Round'  '(' > ?Name=x? Expression[ ',' ?Name=step? Expression[ ',' ?Name=offset? Expression]] ')';

PV_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45099? 'PV'  '(' > ?Name=rate? Expression ',' ?Name=nper? Expression ',' ?Name=pmt? Expression[ ',' ?Name=fv? Expression[ ',' ?Name=type? Expression]] ')';

FV_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45101? 'FV'  '(' > ?Name=rate? Expression ',' ?Name=nper? Expression ',' ?Name=pmt? Expression[ ',' ?Name=pv? Expression[ ',' ?Name=type? Expression]] ')';

Pmt_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45103? 'Pmt'  '(' > ?Name=rate? Expression ',' ?Name=nper? Expression ',' ?Name=pv? Expression[ ',' ?Name=fv? Expression[ ',' ?Name=type? Expression]] ')';

nPer_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45105? 'nPer'  '(' > ?Name=rate? Expression ',' ?Name=pmt? Expression ',' ?Name=pv? Expression[ ',' ?Name=fv? Expression[ ',' ?Name=type? Expression]] ')';

Rate_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45107? 'Rate'  '(' > ?Name=nper? Expression ',' ?Name=pmt? Expression ',' ?Name=pv? Expression[ ',' ?Name=fv? Expression[ ',' ?Name=type? Expression]] ')';

log_Func= ?RetType=num? ?func? < ?FuncGroup=EXP?  ?helpid=45109? 'log'  '(' > ?Name=x? Expression ')';

log10_Func= ?RetType=num? ?func? < ?FuncGroup=EXP?  ?helpid=45111? 'log10'  '(' > ?Name=x? Expression ')';

sin_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG?  ?helpid=45113? 'sin'  '(' > ?Name=x? Expression ')';

sinh_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG?  ?helpid=45115? 'sinh'  '(' > ?Name=x? Expression ')';

sqrt_Func= ?RetType=num? ?func? < ?FuncGroup=EXP?  ?helpid=45117? 'sqrt'  '(' > ?Name=x? Expression ')';

sqr_Func= ?RetType=num? ?func? < ?FuncGroup=EXP?  ?helpid=45119? 'sqr'  '(' > ?Name=x? Expression ')';

tan_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG?  ?helpid=45121? 'tan'  '(' > ?Name=x? Expression ')';

tanh_Func= ?RetType=num? ?func? < ?FuncGroup=TRIG?  ?helpid=45123? 'tanh'  '(' > ?Name=x? Expression ')';

Sign_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45125? 'Sign'  '(' > ?Name=x? Expression ')';

Fact_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45127? 'Fact'  '(' > ?Name=x? Expression ')';

Permut_Func= ?RetType=int? ?func? < ?FuncGroup=NUM?  ?helpid=45129? 'Permut'  '(' > ?Name=p? Expression ',' ?Name=q? Expression ')';

Combin_Func= ?RetType=int? ?func? < ?FuncGroup=NUM?  ?helpid=45131? 'Combin'  '(' > ?Name=p? Expression ',' ?Name=q? Expression ')';

Black_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45133? 'Black'  '(' > [?Name=alpha? Expression] ')';

Blue_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45135? 'Blue'  '(' > [?Name=alpha? Expression] ')';

Green_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45137? 'Green'  '(' > [?Name=alpha? Expression] ')';

Cyan_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45139? 'Cyan'  '(' > [?Name=alpha? Expression] ')';

Red_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45141? 'Red'  '(' > [?Name=alpha? Expression] ')';

Magenta_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45143? 'Magenta'  '(' > [?Name=alpha? Expression] ')';

Brown_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45145? 'Brown'  '(' > [?Name=alpha? Expression] ')';

LightGray_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45147? 'LightGray'  '(' > [?Name=alpha? Expression] ')';

DarkGray_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45149? 'DarkGray'  '(' > [?Name=alpha? Expression] ')';

LightBlue_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45151? 'LightBlue'  '(' > [?Name=alpha? Expression] ')';

LightGreen_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45153? 'LightGreen'  '(' > [?Name=alpha? Expression] ')';

LightCyan_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45155? 'LightCyan'  '(' > [?Name=alpha? Expression] ')';

LightRed_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45157? 'LightRed'  '(' > [?Name=alpha? Expression] ')';

LightMagenta_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45159? 'LightMagenta'  '(' > [?Name=alpha? Expression] ')';

Yellow_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45161? 'Yellow'  '(' > [?Name=alpha? Expression] ')';

White_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45163? 'White'  '(' > [?Name=alpha? Expression] ')';

QlikTechBlue_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45165? 'QlikTechBlue'  '(' > [?Name=alpha? Expression] ')';

QlikTechGray_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45167? 'QlikTechGray'  '(' > [?Name=alpha? Expression] ')';

RangeNPV_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45169? 'RangeNPV'  '(' > ?Name=discount_rate? Expression ',' ?Name=value? Expression{',' Expression} ')';

RangeIRR_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45171? 'RangeIRR'  '(' > ?Name=value? Expression ',' ?Name=value? Expression{',' Expression} ')';

RangeXNPV_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45173? 'RangeXNPV'  '(' > ?Name=discount_rate? Expression ',' ?Name=values? Expression ',' ?Name=dates? Expression{',' Expression} ')';

RangeXIRR_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45175? 'RangeXIRR'  '(' > ?Name=values? Expression ',' ?Name=dates? Expression{',' Expression} ')';

BlackAndSchole_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45177? 'BlackAndSchole'  '(' > ?Name=strike? Expression ',' ?Name=time_left? Expression ',' ?Name=underlying? Expression ',' ?Name=vol? Expression ',' ?Name=risk_free_rate? Expression ',' ?Name=call_or_put? Expression ')';

RangeCorrel_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45179? 'RangeCorrel'  '(' > ?Name=x_values? Expression ',' ?Name=y_values? Expression{',' Expression} ')';

CHIDIST_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45181? 'CHIDIST'  '(' > ?Name=value? Expression ',' ?Name=degrees_freedom? Expression ')';

CHIINV_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45183? 'CHIINV'  '(' > ?Name=prob? Expression ',' ?Name=degrees_freedom? Expression ')';

NORMDIST_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45185? 'NORMDIST'  '(' > ?Name=value? Expression[ ',' ?Name=mean? Expression[ ',' ?Name=standard_dev? Expression[ ',' ?Name=cumulative? Expression]]] ')';

NORMINV_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45187? 'NORMINV'  '(' > ?Name=prob? Expression ',' ?Name=mean? Expression ',' ?Name=standard_dev? Expression ')';

TDIST_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45189? 'TDIST'  '(' > ?Name=value? Expression ',' ?Name=degrees_freedom? Expression ',' ?Name=tails? Expression ')';

TINV_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45191? 'TINV'  '(' > ?Name=prob? Expression ',' ?Name=degrees_freedom? Expression ')';

FDIST_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45193? 'FDIST'  '(' > ?Name=value? Expression ',' ?Name=degrees_freedom1? Expression ',' ?Name=degrees_freedom2? Expression ')';

FINV_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45195? 'FINV'  '(' > ?Name=prob? Expression ',' ?Name=degrees_freedom1? Expression ',' ?Name=degrees_freedom2? Expression ')';

TTest_t_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45197? 'TTest_t'  '(' > ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')';

TTestw_t_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45199? 'TTestw_t'  '(' > ?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')';

TTest_df_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45201? 'TTest_df'  '(' > ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')';

TTestw_df_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45203? 'TTestw_df'  '(' > ?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')';

TTest_sig_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45205? 'TTest_sig'  '(' > ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')';

TTestw_sig_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45207? 'TTestw_sig'  '(' > ?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')';

TTest_dif_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45209? 'TTest_dif'  '(' > ?Name=grp? Expression ',' ?Name=value? Expression ')';

TTestw_dif_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45211? 'TTestw_dif'  '(' > ?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression ')';

TTest_sterr_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45213? 'TTest_sterr'  '(' > ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')';

TTestw_sterr_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45215? 'TTestw_sterr'  '(' > ?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=eq_var? Expression] ')';

TTest_conf_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45217? 'TTest_conf'  '(' > ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')';

TTestw_conf_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45219? 'TTestw_conf'  '(' > ?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')';

TTest_lower_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45221? 'TTest_lower'  '(' > ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')';

TTestw_lower_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45223? 'TTestw_lower'  '(' > ?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')';

TTest_upper_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45225? 'TTest_upper'  '(' > ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')';

TTestw_upper_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45227? 'TTestw_upper'  '(' > ?Name=weight? Expression ',' ?Name=grp? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression[ ',' ?Name=eq_var? Expression]] ')';

TTest1_t_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45229? 'TTest1_t'  '(' > ?Name=value? Expression ')';

TTest1w_t_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45231? 'TTest1w_t'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression ')';

TTest1_df_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45233? 'TTest1_df'  '(' > ?Name=value? Expression ')';

TTest1w_df_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45235? 'TTest1w_df'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression ')';

TTest1_sig_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45237? 'TTest1_sig'  '(' > ?Name=value? Expression ')';

TTest1w_sig_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45239? 'TTest1w_sig'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression ')';

TTest1_dif_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45241? 'TTest1_dif'  '(' > ?Name=value? Expression ')';

TTest1w_dif_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45243? 'TTest1w_dif'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression ')';

TTest1_sterr_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45245? 'TTest1_sterr'  '(' > ?Name=value? Expression ')';

TTest1w_sterr_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45247? 'TTest1w_sterr'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression ')';

TTest1_conf_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45249? 'TTest1_conf'  '(' > ?Name=value? Expression[ ',' ?Name=sig? Expression] ')';

TTest1w_conf_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45251? 'TTest1w_conf'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression] ')';

TTest1_lower_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45253? 'TTest1_lower'  '(' > ?Name=value? Expression[ ',' ?Name=sig? Expression] ')';

TTest1w_lower_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45255? 'TTest1w_lower'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression] ')';

TTest1_upper_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45257? 'TTest1_upper'  '(' > ?Name=value? Expression[ ',' ?Name=sig? Expression] ')';

TTest1w_upper_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45259? 'TTest1w_upper'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sig? Expression] ')';

ZTest_z_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45261? 'ZTest_z'  '(' > ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')';

ZTestw_z_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45263? 'ZTestw_z'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')';

ZTest_sig_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45265? 'ZTest_sig'  '(' > ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')';

ZTestw_sig_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45267? 'ZTestw_sig'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')';

ZTest_dif_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45269? 'ZTest_dif'  '(' > ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')';

ZTestw_dif_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45271? 'ZTestw_dif'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')';

ZTest_sterr_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45273? 'ZTest_sterr'  '(' > ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')';

ZTestw_sterr_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45275? 'ZTestw_sterr'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression] ')';

ZTest_conf_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45277? 'ZTest_conf'  '(' > ?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')';

ZTestw_conf_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45279? 'ZTestw_conf'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')';

ZTest_lower_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45281? 'ZTest_lower'  '(' > ?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')';

ZTestw_lower_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45283? 'ZTestw_lower'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')';

ZTest_upper_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45285? 'ZTest_upper'  '(' > ?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')';

ZTestw_upper_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45287? 'ZTestw_upper'  '(' > ?Name=weight? Expression ',' ?Name=value? Expression[ ',' ?Name=sigma? Expression[ ',' ?Name=sig? Expression]] ')';

Chi2Test_p_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45289? 'Chi2Test_p'  '(' > ?Name=col? Expression ',' ?Name=row? Expression ',' ?Name=actual_value? Expression[ ',' ?Name=expected_value? Expression] ')';

Chi2Test_df_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45291? 'Chi2Test_df'  '(' > ?Name=col? Expression ',' ?Name=row? Expression ',' ?Name=actual_value? Expression[ ',' ?Name=expected_value? Expression] ')';

Chi2Test_chi2_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45293? 'Chi2Test_chi2'  '(' > ?Name=col? Expression ',' ?Name=row? Expression ',' ?Name=actual_value? Expression[ ',' ?Name=expected_value? Expression] ')';

If_Func= ?RetType=dual? ?func? < ?FuncGroup=CND?  ?helpid=45295? 'If'  '(' > ?Name=condition? Expression ',' ?Name=then_expr? Expression[ ',' ?Name=else_expr? Expression] ')';

Pick_Func= ?RetType=dual? ?func? < ?FuncGroup=CND?  ?helpid=45297? 'Pick'  '(' > ?Name=position? Expression{',' Expression} ')';

Match_Func= ?RetType=int? ?func? < ?FuncGroup=CND?  ?helpid=45299? 'Match'  '(' > ?Name=text? Expression ',' ?Name=mask_expr1? Expression{',' Expression} ')';

MixMatch_Func= ?RetType=int? ?func? < ?FuncGroup=CND?  ?helpid=45301? 'MixMatch'  '(' > ?Name=text? Expression ',' ?Name=mask_expr1? Expression{',' Expression} ')';

WildMatch_Func= ?RetType=int? ?func? < ?FuncGroup=CND?  ?helpid=45303? 'WildMatch'  '(' > ?Name=text? Expression ',' ?Name=mask_expr1? Expression{',' Expression} ')';

Alt_Func= ?RetType=dual? ?func? < ?FuncGroup=CND?  ?helpid=45305? 'Alt'  '(' > ?Name=expr1? Expression{',' Expression} ')';

Trim_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45307? 'Trim'  '(' > ?Name=text? Expression ')';

LTrim_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45309? 'LTrim'  '(' > ?Name=text? Expression ')';

RTrim_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45311? 'RTrim'  '(' > ?Name=text? Expression ')';

PurgeChar_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45313? 'PurgeChar'  '(' > ?Name=text? Expression ',' ?Name=remove_chars? Expression ')';

LevenshteinDist_Func= ?RetType=int? ?func? < ?FuncGroup=STR?  ?helpid=45315? 'LevenshteinDist'  '(' > ?Name=text1? Expression ',' ?Name=text2? Expression ')';

KeepChar_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45317? 'KeepChar'  '(' > ?Name=text? Expression ',' ?Name=keep_chars? Expression ')';

Left_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45319? 'Left'  '(' > ?Name=text? Expression ',' ?Name=count? Expression ')';

Right_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45321? 'Right'  '(' > ?Name=text? Expression ',' ?Name=count? Expression ')';

Mid_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45323? 'Mid'  '(' > ?Name=text? Expression ',' ?Name=start? Expression[ ',' ?Name=count? Expression] ')';

SubField_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45325? 'SubField'  '(' > ?Name=text? Expression ',' ?Name=delimiter? Expression[ ',' ?Name=field_no? Expression] ')';

TextBetween_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45327? 'TextBetween'  '(' > ?Name=text? Expression ',' ?Name=delimiter1? Expression ',' ?Name=delimiter2? Expression[ ',' ?Name=count? Expression] ')';

Repeat_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45329? 'Repeat'  '(' > ?Name=text? Expression ',' ?Name=repeat_count? Expression ')';

Chr_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45331? 'Chr'  '(' > ?Name=int? Expression ')';

Class_Func= ?RetType=str? ?func? < ?FuncGroup=CND?  ?helpid=45333? 'Class'  '(' > ?Name=x? Expression ',' ?Name=class_width? Expression[ ',' ?Name=formal? Expression[ ',' ?Name=bias? Expression]] ')';

Index_Func= ?RetType=int? ?func? < ?FuncGroup=STR?  ?helpid=45335? 'Index'  '(' > ?Name=text? Expression ',' ?Name=substring? Expression[ ',' ?Name=count? Expression] ')';

FindOneOf_Func= ?RetType=int? ?func? < ?FuncGroup=STR?  ?helpid=45337? 'FindOneOf'  '(' > ?Name=text? Expression ',' ?Name=char_set? Expression[ ',' ?Name=count? Expression] ')';

Len_Func= ?RetType=int? ?func? < ?FuncGroup=STR?  ?helpid=45339? 'Len'  '(' > ?Name=text? Expression ')';

Mod_Func= ?RetType=int? ?func? < ?FuncGroup=NUM?  ?helpid=45341? 'Mod'  '(' > ?Name=integer_number1? Expression ',' ?Name=integer_number2? Expression ')';

Odd_Func= ?RetType=bool? ?func? < ?FuncGroup=NUM?  ?helpid=45343? 'Odd'  '(' > ?Name=integer_number? Expression ')';

Even_Func= ?RetType=bool? ?func? < ?FuncGroup=NUM?  ?helpid=45345? 'Even'  '(' > ?Name=integer_number? Expression ')';

UTC_Func= ?RetType=num? ?func? < ?FuncGroup=DATE?  ?helpid=45347? 'UTC'  '(' > [?Name=realtime? Expression] ')';

GMT_Func= ?RetType=num? ?func? < ?FuncGroup=DATE?  ?helpid=45349? 'GMT'  '(' > [?Name=realtime? Expression] ')';

Now_Func= ?RetType=num? ?func? < ?FuncGroup=DATE?  ?helpid=45351? 'Now'  '(' > [?Name=timer_mode? Expression] ')';

Today_Func= ?RetType=num? ?func? < ?FuncGroup=DATE?  ?helpid=45353? 'Today'  '(' > [?Name=timer_mode? Expression] ')';

Hour_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45355? 'Hour'  '(' > ?Name=timestamp? Expression ')';

Minute_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45357? 'Minute'  '(' > ?Name=timestamp? Expression ')';

Second_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45359? 'Second'  '(' > ?Name=timestamp? Expression ')';

Frac_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45361? 'Frac'  '(' > ?Name=timestamp? Expression ')';

Div_Func= ?RetType=int? ?func? < ?FuncGroup=NUM?  ?helpid=45363? 'Div'  '(' > ?Name=integer_number1? Expression ',' ?Name=integer_number2? Expression ')';

Dual_Func= ?RetType=dual? ?func? < ?FuncGroup=FRMT?  ?helpid=45365? 'Dual'  '(' > ?Name=text? Expression ',' ?Name=number? Expression ')';

BitCount_Func= ?RetType=int? ?func? < ?FuncGroup=NUM?  ?helpid=45367? 'BitCount'  '(' > ?Name=integer_number? Expression ')';

Ord_Func= ?RetType=int? ?func? < ?FuncGroup=STR?  ?helpid=45369? 'Ord'  '(' > ?Name=char? Expression ')';

Upper_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45371? 'Upper'  '(' > ?Name=text? Expression ')';

ApplyCodepage_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45373? 'ApplyCodepage'  '(' > ?Name=text? Expression ',' ?Name=codepage? Expression ')';

Lower_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45375? 'Lower'  '(' > ?Name=text? Expression ')';

Capitalize_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45377? 'Capitalize'  '(' > ?Name=text? Expression ')';

RGB_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45379? 'RGB'  '(' > ?Name=r_value? Expression ',' ?Name=g_value? Expression ',' ?Name=b_value? Expression ')';

ARGB_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45381? 'ARGB'  '(' > ?Name=alpha_value? Expression ',' ?Name=r_value? Expression ',' ?Name=g_value? Expression ',' ?Name=b_value? Expression ')';

HSL_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45383? 'HSL'  '(' > ?Name=hue? Expression ',' ?Name=saturation? Expression ',' ?Name=luminosity? Expression ')';

Color_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45385? 'Color'  '(' > ?Name=palette_index? Expression ')';

SysColor_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45387? 'SysColor'  '(' > ?Name=sys_index? Expression ')';

ColorMix1_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45389? 'ColorMix1'  '(' > ?Name=ValueBetweenZeroAndOne? Expression ',' ?Name=ColorZero? Expression ',' ?Name=ColorOne? Expression ')';

ColorMix2_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45391? 'ColorMix2'  '(' > ?Name=ValueBetweenMinusOneAndOne? Expression ',' ?Name=ColorMinusOne? Expression ',' ?Name=ColorOne? Expression[ ',' ?Name=ColorZero? Expression] ')';

ColorMapJet_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45393? 'ColorMapJet'  '(' > ?Name=ValueBetweenZeroAndOne? Expression ')';

ColorMapHue_Func= ?RetType=int? ?func? < ?FuncGroup=CLR?  ?helpid=45395? 'ColorMapHue'  '(' > ?Name=ValueBetweenZeroAndOne? Expression ')';

IsNull_Func= ?RetType=bool? ?func? < ?FuncGroup=NULL?  ?helpid=45397? 'IsNull'  '(' > ?Name=expr? Expression ')';

IsNum_Func= ?RetType=bool? ?func? < ?FuncGroup=LOG?  ?helpid=45399? 'IsNum'  '(' > ?Name=expr? Expression ')';

IsText_Func= ?RetType=bool? ?func? < ?FuncGroup=LOG?  ?helpid=45401? 'IsText'  '(' > ?Name=expr? Expression ')';

RecNo_Func= ?RetType=int? ?func? < ?FuncGroup=COUNT?  ?helpid=45403? 'RecNo'  '(' >  ')';

IterNo_Func= ?RetType=int? ?func? < ?FuncGroup=COUNT?  ?helpid=45404? 'IterNo'  '(' >  ')';

NoOfRows_Func= ?RetType=int? ?func? < ?FuncGroup=TBL?  ?helpid=45405? 'NoOfRows'  '(' > ?Name=table_name? Expression ')';

NoOfFields_Func= ?RetType=int? ?func? < ?FuncGroup=TBL?  ?helpid=45406? 'NoOfFields'  '(' > ?Name=table_name? Expression ')';

FieldName_Func= ?RetType=str? ?func? < ?FuncGroup=TBL?  ?helpid=45407? 'FieldName'  '(' > ?Name=field_number? Expression ',' ?Name=table_name? Expression ')';

FieldNumber_Func= ?RetType=int? ?func? < ?FuncGroup=TBL?  ?helpid=45408? 'FieldNumber'  '(' > ?Name=field_name? Expression ',' ?Name=table_name? Expression ')';

RowNo_Func= ?RetType=int? ?func? < ?FuncGroup=COUNT?  ?helpid=45409? 'RowNo'  '(' > ['TOTAL'] ')';

Timestamp_Func= ?RetType=dual? ?func? < ?FuncGroup=FRMT?  ?helpid=45417? 'Timestamp'  '(' > ?Name=number? Expression[ ',' ?Name=format? Expression] ')';

Date_Func= ?RetType=dual? ?func? < ?FuncGroup=FRMT?  ?helpid=45419? 'Date'  '(' > ?Name=number? Expression[ ',' ?Name=format? Expression] ')';

Time_Func= ?RetType=dual? ?func? < ?FuncGroup=FRMT?  ?helpid=45421? 'Time'  '(' > ?Name=number? Expression[ ',' ?Name=format? Expression] ')';

Interval_Func= ?RetType=dual? ?func? < ?FuncGroup=FRMT?  ?helpid=45423? 'Interval'  '(' > ?Name=number? Expression[ ',' ?Name=format? Expression] ')';

Num_Func= ?RetType=dual? ?func? < ?FuncGroup=FRMT?  ?helpid=45425? 'Num'  '(' > ?Name=number? Expression[ ',' ?Name=format? Expression[ ',' ?Name=dec_sep? Expression[ ',' ?Name=thou_sep? Expression]]] ')';

Money_Func= ?RetType=dual? ?func? < ?FuncGroup=FRMT?  ?helpid=45427? 'Money'  '(' > ?Name=number? Expression[ ',' ?Name=format? Expression[ ',' ?Name=dec_sep? Expression[ ',' ?Name=thou_sep? Expression]]] ')';

Text_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI?  ?helpid=45429? 'Text'  '(' > ?Name=expr? Expression ')';

Timestamp#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI?  ?helpid=45431? 'Timestamp#'  '(' > ?Name=text? Expression[ ',' ?Name=format? Expression] ')';

Date#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI?  ?helpid=45433? 'Date#'  '(' > ?Name=text? Expression[ ',' ?Name=format? Expression] ')';

Time#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI?  ?helpid=45435? 'Time#'  '(' > ?Name=text? Expression[ ',' ?Name=format? Expression] ')';

Interval#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI?  ?helpid=45437? 'Interval#'  '(' > ?Name=text? Expression[ ',' ?Name=format? Expression] ')';

Num#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI?  ?helpid=45439? 'Num#'  '(' > ?Name=text? Expression[ ',' ?Name=format? Expression[ ',' ?Name=dec_sep? Expression[ ',' ?Name=thou_sep? Expression]]] ')';

Money#_Func= ?RetType=dual? ?func? < ?FuncGroup=NUMI?  ?helpid=45441? 'Money#'  '(' > ?Name=text? Expression[ ',' ?Name=format? Expression[ ',' ?Name=dec_sep? Expression[ ',' ?Name=thou_sep? Expression]]] ')';

Month_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45443? 'Month'  '(' > ?Name=timestamp? Expression ')';

Day_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45445? 'Day'  '(' > ?Name=timestamp? Expression ')';

Week_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45447? 'Week'  '(' > ?Name=timestamp? Expression[ ',' ?Name=first_week_day? Expression[ ',' ?Name=broken_weeks? Expression[ ',' ?Name=reference_day? Expression]]] ')';

WeekDay_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45449? 'WeekDay'  '(' > ?Name=timestamp? Expression[ ',' ?Name=first_week_day? Expression] ')';

WeekYear_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45451? 'WeekYear'  '(' > ?Name=timestamp? Expression ')';

Year_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45453? 'Year'  '(' > ?Name=timestamp? Expression ')';

Age_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45455? 'Age'  '(' > ?Name=timestamp? Expression ',' ?Name=date_of_birth? Expression ')';

NetWorkDays_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45457? 'NetWorkDays'  '(' > ?Name=start_date? Expression ',' ?Name=end_date? Expression[ ',' ?Name=holiday? Expression{',' Expression}] ')';

LastWorkDate_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45459? 'LastWorkDate'  '(' > ?Name=start_date? Expression ',' ?Name=no_of_workdays? Expression[ ',' ?Name=holiday? Expression{',' Expression}] ')';

FirstWorkDate_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45461? 'FirstWorkDate'  '(' > ?Name=end_date? Expression ',' ?Name=no_of_workdays? Expression[ ',' ?Name=holiday? Expression{',' Expression}] ')';

MakeDate_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45463? 'MakeDate'  '(' > ?Name=year_number? Expression[ ',' ?Name=month_number? Expression[ ',' ?Name=day_number? Expression]] ')';

MakeWeekDate_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45465? 'MakeWeekDate'  '(' > ?Name=weekyear_number? Expression ',' ?Name=week_number? Expression[ ',' ?Name=weekday_number? Expression] ')';

AddMonths_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45467? 'AddMonths'  '(' > ?Name=date? Expression ',' ?Name=no_of_months? Expression[ ',' ?Name=mode? Expression] ')';

AddYears_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45469? 'AddYears'  '(' > ?Name=date? Expression ',' ?Name=no_of_years? Expression ')';

MakeTime_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45471? 'MakeTime'  '(' > ?Name=hour? Expression[ ',' ?Name=minute? Expression[ ',' ?Name=second? Expression]] ')';

NumSum_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45473? ?deprecated? 'NumSum'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

NumMin_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45475? ?deprecated? 'NumMin'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

NumMax_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45477? ?deprecated? 'NumMax'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

NumAvg_Func= ?RetType=num? ?func? < ?FuncGroup=NUM?  ?helpid=45479? ?deprecated? 'NumAvg'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

NumCount_Func= ?RetType=int? ?func? < ?FuncGroup=NUM?  ?helpid=45481? ?deprecated? 'NumCount'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeNumericCount_Func= ?RetType=int? ?func? < ?FuncGroup=RNG?  ?helpid=45483? 'RangeNumericCount'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeSum_Func= ?RetType=num? ?func? < ?FuncGroup=RNG?  ?helpid=45485? 'RangeSum'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeMin_Func= ?RetType=num? ?func? < ?FuncGroup=RNG?  ?helpid=45487? 'RangeMin'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeMax_Func= ?RetType=num? ?func? < ?FuncGroup=RNG?  ?helpid=45489? 'RangeMax'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeAvg_Func= ?RetType=num? ?func? < ?FuncGroup=RNG?  ?helpid=45491? 'RangeAvg'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeStdev_Func= ?RetType=num? ?func? < ?FuncGroup=RNG?  ?helpid=45493? 'RangeStdev'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeSkew_Func= ?RetType=num? ?func? < ?FuncGroup=RNG?  ?helpid=45495? 'RangeSkew'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeKurtosis_Func= ?RetType=num? ?func? < ?FuncGroup=RNG?  ?helpid=45497? 'RangeKurtosis'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeNullCount_Func= ?RetType=int? ?func? < ?FuncGroup=RNG?  ?helpid=45499? 'RangeNullCount'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeTextCount_Func= ?RetType=int? ?func? < ?FuncGroup=RNG?  ?helpid=45501? 'RangeTextCount'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeMissingCount_Func= ?RetType=int? ?func? < ?FuncGroup=RNG?  ?helpid=45503? 'RangeMissingCount'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeCount_Func= ?RetType=int? ?func? < ?FuncGroup=RNG?  ?helpid=45505? 'RangeCount'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeOnly_Func= ?RetType=dual? ?func? < ?FuncGroup=RNG?  ?helpid=45507? 'RangeOnly'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeMinString_Func= ?RetType=str? ?func? < ?FuncGroup=RNG?  ?helpid=45509? 'RangeMinString'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeMaxString_Func= ?RetType=str? ?func? < ?FuncGroup=RNG?  ?helpid=45511? 'RangeMaxString'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeMode_Func= ?RetType=num? ?func? < ?FuncGroup=RNG?  ?helpid=45513? 'RangeMode'  '(' > ?Name=first_expr? Expression{',' Expression} ')';

RangeFractile_Func= ?RetType=num? ?func? < ?FuncGroup=RNG?  ?helpid=45515? 'RangeFractile'  '(' > ?Name=fractile? Expression ',' ?Name=first_expr? Expression{',' Expression} ')';

Previous_Func= ?RetType=dual? ?func? < ?FuncGroup=RNG?  ?helpid=45517? 'Previous'  '(' > ?Name=expr? Expression ')';

Peek_Func= ?RetType=dual? ?func? < ?FuncGroup=RCRD?  ?helpid=45518? 'Peek'  '(' > ?Name=field_name? Expression[ ',' ?Name=row_no? Expression[ ',' ?Name=table_name? Expression]] ')';

Lookup_Func= ?RetType=dual? ?func? < ?FuncGroup=RCRD?  ?helpid=45519? 'Lookup'  '(' > ?Name=field_name? Expression ',' ?Name=match_field_name? Expression ',' ?Name=match_field_value? Expression[ ',' ?Name=table_name? Expression] ')';

Exists_Func= ?RetType=bool? ?func? < ?FuncGroup=RCRD?  ?helpid=45531? 'Exists'  '(' > ?Name=field_name? Expression[ ',' ?Name=expr? Expression] ')';

FieldValue_Func= ?RetType=dual? ?func? < ?FuncGroup=RCRD?  ?helpid=45533? 'FieldValue'  '(' > ?Name=field_name? Expression ',' ?Name=elem_no? Expression ')';

FieldValueCount_Func= ?RetType=int? ?func? < ?FuncGroup=RCRD?  ?helpid=45535? 'FieldValueCount'  '(' > ?Name=field_name? Expression ')';

FieldIndex_Func= ?RetType=int? ?func? < ?FuncGroup=RCRD?  ?helpid=45537? 'FieldIndex'  '(' > ?Name=field_name? Expression ',' ?Name=value? Expression ')';

FieldElemNo_Func= ?RetType=int? ?func? < ?FuncGroup=RCRD?  ?helpid=45539? 'FieldElemNo'  '(' > ?Name=field_name? Expression ')';

AutoNumber_Func= ?RetType=int? ?func? < ?FuncGroup=COUNT?  ?helpid=45551? 'AutoNumber'  '(' > ?Name=expr? Expression[ ',' ?Name=id? Expression] ')';

AutoNumberHash128_Func= ?RetType=int? ?func? < ?FuncGroup=COUNT?  ?helpid=45552? 'AutoNumberHash128'  '(' > ?Name=expr? Expression{',' Expression} ')';

AutoNumberHash256_Func= ?RetType=int? ?func? < ?FuncGroup=COUNT?  ?helpid=45553? 'AutoNumberHash256'  '(' > ?Name=expr? Expression{',' Expression} ')';

Hash128_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45554? 'Hash128'  '(' > ?Name=expr? Expression{',' Expression} ')';

Hash160_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45556? 'Hash160'  '(' > ?Name=expr? Expression{',' Expression} ')';

Hash256_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45558? 'Hash256'  '(' > ?Name=expr? Expression{',' Expression} ')';

ApplyMap_Func= ?RetType=dual? ?func? < ?FuncGroup=MAPP?  ?helpid=45560? 'ApplyMap'  '(' > ?Name=map_id? Expression ',' ?Name=expr? Expression[ ',' ?Name=default_mapping? Expression] ')';

MapSubString_Func= ?RetType=str? ?func? < ?FuncGroup=MAPP?  ?helpid=45561? 'MapSubString'  '(' > ?Name=map_id? Expression ',' ?Name=text? Expression ')';

Replace_Func= ?RetType=str? ?func? < ?FuncGroup=STR?  ?helpid=45562? 'Replace'  '(' > ?Name=text? Expression ',' ?Name=from_str? Expression ',' ?Name=to_str? Expression ')';

SubStringCount_Func= ?RetType=num? ?func? < ?FuncGroup=STR?  ?helpid=45564? 'SubStringCount'  '(' > ?Name=text? Expression ',' ?Name=sub_string? Expression ')';

Evaluate_Func= ?RetType=dual? ?func? < ?FuncGroup=STR?  ?helpid=45566? 'Evaluate'  '(' > ?Name=expression_text? Expression ')';

OSUser_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45567? 'OSUser'  '(' >  ')';

GetDataModelHash_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45569? 'GetDataModelHash'  '(' >  ')';

DocumentPath_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45571? 'DocumentPath'  '(' >  ')';

DocumentName_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45573? 'DocumentName'  '(' >  ')';

DocumentTitle_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45575? 'DocumentTitle'  '(' >  ')';

NoOfTables_Func= ?RetType=num? ?func? < ?FuncGroup=SYS?  ?helpid=45577? 'NoOfTables'  '(' >  ')';

TableName_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45578? 'TableName'  '(' > ?Name=table_number? Expression ')';

TableNumber_Func= ?RetType=num? ?func? < ?FuncGroup=SYS?  ?helpid=45579? 'TableNumber'  '(' > ?Name=table_name? Expression ')';

ReportComment_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45580? 'ReportComment'  '(' > ?Name=report_number? Expression ')';

ReportName_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45582? 'ReportName'  '(' > ?Name=report_number? Expression ')';

ReportId_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45584? 'ReportId'  '(' > ?Name=report_number? Expression ')';

ReportNumber_Func= ?RetType=num? ?func? < ?FuncGroup=SYS?  ?helpid=45586? 'ReportNumber'  '(' > ?Name=report_id_or_name? Expression ')';

NoOfReports_Func= ?RetType=num? ?func? < ?FuncGroup=SYS?  ?helpid=45588? 'NoOfReports'  '(' >  ')';

GetCollationLocale_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45590? 'GetCollationLocale'  '(' >  ')';

MsgBox_Func= ?RetType=num? ?func? < ?FuncGroup=SYS?  ?helpid=45592? 'MsgBox'  '(' > ?Name=msg? Expression[ ',' ?Name=caption? Expression[ ',' ?Name=mb_buttons? Expression[ ',' ?Name=mb_icons? Expression[ ',' ?Name=mb_defbutton? Expression]]]] ')';

Input_Func= ?RetType=dual? ?func? < ?FuncGroup=SYS?  ?helpid=45593? 'Input'  '(' > ?Name=cue? Expression[ ',' ?Name=caption? Expression] ')';

QlikViewVersion_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45594? 'QlikViewVersion'  '(' >  ')';

ProductVersion_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45596? 'ProductVersion'  '(' >  ')';

QVUser_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45598? 'QVUser'  '(' >  ')';

GetRegistryString_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45600? 'GetRegistryString'  '(' > ?Name=path? Expression ',' ?Name=key? Expression ')';

ComputerName_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45602? 'ComputerName'  '(' >  ')';

Author_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45604? 'Author'  '(' >  ')';

ReloadTime_Func= ?RetType=dual? ?func? < ?FuncGroup=SYS?  ?helpid=45606? 'ReloadTime'  '(' >  ')';

GetObjectField_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45608? 'GetObjectField'  '(' > [?Name=index? Expression[ ',' ?Name=objectid? Expression]] ')';

GetExtendedProperty_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45610? 'GetExtendedProperty'  '(' > [?Name=name? Expression[ ',' ?Name=objectid? Expression]] ')';

ClientPlatform_Func= ?RetType=str? ?func? < ?FuncGroup=SYS?  ?helpid=45612? 'ClientPlatform'  '(' >  ')';

DayNumberOfYear_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45614? 'DayNumberOfYear'  '(' > ?Name=timestamp? Expression[ ',' ?Name=start_month? Expression] ')';

DayNumberOfQuarter_Func= ?RetType=int? ?func? < ?FuncGroup=DATE?  ?helpid=45616? 'DayNumberOfQuarter'  '(' > ?Name=timestamp? Expression[ ',' ?Name=start_month? Expression] ')';

Year2Date_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45618? ?deprecated? 'Year2Date'  '(' > ?Name=timestamp? Expression[ ',' ?Name=year_offset? Expression[ ',' ?Name=start_month? Expression[ ',' ?Name=ref_timestamp? Expression]]] ')';

YearToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45620? 'YearToDate'  '(' > ?Name=timestamp? Expression[ ',' ?Name=year_offset? Expression[ ',' ?Name=start_month? Expression[ ',' ?Name=ref_timestamp? Expression]]] ')';

InYear_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45622? 'InYear'  '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')';

InYearToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45624? 'InYearToDate'  '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')';

InQuarter_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45626? 'InQuarter'  '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')';

InQuarterToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45628? 'InQuarterToDate'  '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')';

InMonth_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45630? 'InMonth'  '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')';

InMonthToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45632? 'InMonthToDate'  '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')';

InMonths_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45634? 'InMonths'  '(' > ?Name=n_months? Expression ',' ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')';

InMonthsToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45636? 'InMonthsToDate'  '(' > ?Name=n_months? Expression ',' ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression] ')';

InWeek_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45638? 'InWeek'  '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression] ')';

InWeekToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45640? 'InWeekToDate'  '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression] ')';

InLunarWeek_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45642? 'InLunarWeek'  '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression] ')';

InLunarWeekToDate_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45644? 'InLunarWeekToDate'  '(' > ?Name=timestamp? Expression ',' ?Name=base_date? Expression ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression] ')';

InDay_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45646? 'InDay'  '(' > ?Name=timestamp? Expression ',' ?Name=base_timestamp? Expression ',' ?Name=period_no? Expression[ ',' ?Name=day_start? Expression] ')';

InDayToTime_Func= ?RetType=bool? ?func? < ?FuncGroup=DATE?  ?helpid=45648? 'InDayToTime'  '(' > ?Name=timestamp? Expression ',' ?Name=base_timestamp? Expression ',' ?Name=period_no? Expression[ ',' ?Name=day_start? Expression] ')';

YearStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45650? 'YearStart'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')';

QuarterStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45652? 'QuarterStart'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')';

MonthStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45654? 'MonthStart'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression] ')';

MonthsStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45656? 'MonthsStart'  '(' > ?Name=n_months? Expression ',' ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')';

WeekStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45658? 'WeekStart'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')';

LunarWeekStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45660? 'LunarWeekStart'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')';

DayStart_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45662? 'DayStart'  '(' > ?Name=time? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=day_start? Expression]] ')';

YearEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45664? 'YearEnd'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')';

QuarterEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45666? 'QuarterEnd'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')';

MonthEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45668? 'MonthEnd'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression] ')';

MonthsEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45670? 'MonthsEnd'  '(' > ?Name=n_months? Expression ',' ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')';

WeekEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45672? 'WeekEnd'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')';

LunarWeekEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45674? 'LunarWeekEnd'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')';

DayEnd_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45676? 'DayEnd'  '(' > ?Name=time? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=day_start? Expression]] ')';

YearName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45678? 'YearName'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')';

QuarterName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45680? 'QuarterName'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')';

MonthName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45682? 'MonthName'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression] ')';

MonthsName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45684? 'MonthsName'  '(' > ?Name=n_months? Expression ',' ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_month_of_year? Expression]] ')';

WeekName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45686? 'WeekName'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')';

LunarWeekName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45688? 'LunarWeekName'  '(' > ?Name=date? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=first_week_day? Expression]] ')';

DayName_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45690? 'DayName'  '(' > ?Name=time? Expression[ ',' ?Name=period_no? Expression[ ',' ?Name=day_start? Expression]] ')';

SetDateYear_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45692? 'SetDateYear'  '(' > ?Name=timestamp? Expression ',' ?Name=year? Expression ')';

SetDateYearMonth_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45694? 'SetDateYearMonth'  '(' > ?Name=timestamp? Expression ',' ?Name=year? Expression ',' ?Name=month? Expression ')';

LocalTime_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45696? 'LocalTime'  '(' > [?Name=place? Expression[ ',' ?Name=ignore_dst? Expression]] ')';

ConvertToLocalTime_Func= ?RetType=dual? ?func? < ?FuncGroup=DATE?  ?helpid=45698? 'ConvertToLocalTime'  '(' > ?Name=timestamp? Expression[ ',' ?Name=place? Expression[ ',' ?Name=ignore_dst? Expression]] ')';

QvdCreateTime_Func= ?RetType=num? ?func? < ?FuncGroup=FILE?  ?helpid=45700? 'QvdCreateTime'  '(' > ?Name=qvd_file_name? Expression ')';

QvdNoOfRecords_Func= ?RetType=num? ?func? < ?FuncGroup=FILE?  ?helpid=45701? 'QvdNoOfRecords'  '(' > ?Name=qvd_file_name? Expression ')';

QvdNoOfFields_Func= ?RetType=num? ?func? < ?FuncGroup=FILE?  ?helpid=45702? 'QvdNoOfFields'  '(' > ?Name=qvd_file_name? Expression ')';

QvdFieldName_Func= ?RetType=str? ?func? < ?FuncGroup=FILE?  ?helpid=45703? 'QvdFieldName'  '(' > ?Name=qvd_file_name? Expression ',' ?Name=field_no? Expression ')';

QvdTableName_Func= ?RetType=str? ?func? < ?FuncGroup=FILE?  ?helpid=45704? 'QvdTableName'  '(' > ?Name=qvd_file_name? Expression ')';

FileTime_Func= ?RetType=num? ?func? < ?FuncGroup=FILE?  ?helpid=45705? 'FileTime'  '(' > [?Name=file_name? Expression] ')';

FileSize_Func= ?RetType=int? ?func? < ?FuncGroup=FILE?  ?helpid=45706? 'FileSize'  '(' > [?Name=file_name? Expression] ')';

Attribute_Func= ?RetType=dual? ?func? < ?FuncGroup=FILE?  ?helpid=45707? 'Attribute'  '(' > ?Name=file_name? Expression ',' ?Name=attribute_name? Expression ')';

FilePath_Func= ?RetType=str? ?func? < ?FuncGroup=FILE?  ?helpid=45708? 'FilePath'  '(' > [?Name=file_name? Expression] ')';

FileName_Func= ?RetType=str? ?func? < ?FuncGroup=FILE?  ?helpid=45709? 'FileName'  '(' > [?Name=file_name? Expression] ')';

FileDir_Func= ?RetType=str? ?func? < ?FuncGroup=FILE?  ?helpid=45710? 'FileDir'  '(' > [?Name=file_name? Expression] ')';

GetFolderPath_Func= ?RetType=str? ?func? < ?FuncGroup=FILE?  ?helpid=45711? 'GetFolderPath'  '(' > [?Name=folder? Expression] ')';

FileBaseName_Func= ?RetType=str? ?func? < ?FuncGroup=FILE?  ?helpid=45712? 'FileBaseName'  '(' > [?Name=file_name? Expression] ')';

FileExtension_Func= ?RetType=str? ?func? < ?FuncGroup=FILE?  ?helpid=45713? 'FileExtension'  '(' > [?Name=file_name? Expression] ')';

IsPartialReload_Func= ?RetType=bool? ?func? < ?FuncGroup=SYS?  ?helpid=45714? 'IsPartialReload'  '(' >  ')';

ConnectString_Func= ?RetType=str? ?func? < ?FuncGroup=FILE?  ?helpid=45715? 'ConnectString'  '(' >  ')';

Sum_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45719? 'Sum'  '(' > ['DISTINCT']?Name=expr? Expression ')';

Min_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45721? 'Min'  '(' > ?Name=expr? Expression[ ',' ?Name=rank? Expression] ')';

Max_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45723? 'Max'  '(' > ?Name=expr? Expression[ ',' ?Name=rank? Expression] ')';

Avg_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45725? 'Avg'  '(' > ['DISTINCT']?Name=expr? Expression ')';

Stdev_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45727? 'Stdev'  '(' > ['DISTINCT']?Name=expr? Expression ')';

Skew_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45729? 'Skew'  '(' > ['DISTINCT']?Name=expr? Expression ')';

Kurtosis_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45731? 'Kurtosis'  '(' > ['DISTINCT']?Name=expr? Expression ')';

NumericCount_Func= ?RetType=int? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45733? 'NumericCount'  '(' > ['DISTINCT']?Name=expr? Expression ')';

NullCount_Func= ?RetType=int? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45735? 'NullCount'  '(' > ['DISTINCT']?Name=expr? Expression ')';

TextCount_Func= ?RetType=int? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45737? 'TextCount'  '(' > ['DISTINCT']?Name=expr? Expression ')';

Count_Func= ?RetType=int? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45739? 'Count'  '(' > ['DISTINCT']?Name=expr? Expression ')';

MissingCount_Func= ?RetType=int? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45741? 'MissingCount'  '(' > ['DISTINCT']?Name=expr? Expression ')';

MinString_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45743? 'MinString'  '(' > ?Name=expr? Expression ')';

MaxString_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45745? 'MaxString'  '(' > ?Name=expr? Expression ')';

Only_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45747? 'Only'  '(' > ?Name=expr? Expression ')';

Mode_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45749? 'Mode'  '(' > ?Name=expr? Expression ')';

Fractile_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45751? 'Fractile'  '(' > ['TOTAL']['ALL']['DISTINCT']?Name=expr? Expression ',' ?Name=fraction? Expression ')';

Median_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45753? 'Median'  '(' > ['TOTAL']['ALL']['DISTINCT']?Name=expr? Expression ')';

FirstValue_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45755? 'FirstValue'  '(' > ?Name=expr? Expression ')';

LastValue_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45756? 'LastValue'  '(' > ?Name=expr? Expression ')';

Sterr_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45757? 'Sterr'  '(' > ['DISTINCT']?Name=expr? Expression ')';

Concat_Func= ?RetType=str? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45759? 'Concat'  '(' > ['DISTINCT']['TOTAL']?Name=string? Expression[ ',' ?Name=delimiter? Expression[ ',' ?Name=sort_weight? Expression]] ')';

FirstSortedValue_Func= ?RetType=dual? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45761? 'FirstSortedValue'  '(' > ['DISTINCT']['ALL']['TOTAL']?Name=value? Expression ',' ?Name=sort_weight? Expression[ ',' ?Name=rank? Expression] ')';

NPV_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45767? 'NPV'  '(' > ?Name=discount_rate? Expression ',' ?Name=value? Expression ')';

IRR_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45768? 'IRR'  '(' > ?Name=value? Expression ')';

XNPV_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45769? 'XNPV'  '(' > ?Name=discount_rate? Expression ',' ?Name=pmt? Expression ',' ?Name=date? Expression ')';

XIRR_Func= ?RetType=num? ?func? < ?FuncGroup=FIN?  ?helpid=45770? 'XIRR'  '(' > ?Name=pmt? Expression ',' ?Name=date? Expression ')';

Correl_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45771? 'Correl'  '(' > ['TOTAL']?Name=value1? Expression ',' ?Name=value2? Expression ')';

STEYX_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45773? 'STEYX'  '(' > ['TOTAL']?Name=y_value? Expression ',' ?Name=x_value? Expression ')';

LINEST_B_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45775? 'LINEST_B'  '(' > ['TOTAL']?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')';

LINEST_DF_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45777? 'LINEST_DF'  '(' > ['TOTAL']?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')';

LINEST_F_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45779? 'LINEST_F'  '(' > ['TOTAL']?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')';

LINEST_M_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45781? 'LINEST_M'  '(' > ['TOTAL']?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')';

LINEST_R2_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45783? 'LINEST_R2'  '(' > ['TOTAL']?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')';

LINEST_SEB_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45785? 'LINEST_SEB'  '(' > ['TOTAL']?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')';

LINEST_SEM_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45787? 'LINEST_SEM'  '(' > ['TOTAL']?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')';

LINEST_SEY_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45789? 'LINEST_SEY'  '(' > ['TOTAL']?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')';

LINEST_SSREG_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45791? 'LINEST_SSREG'  '(' > ['TOTAL']?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')';

LINEST_SSRESID_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45793? 'LINEST_SSRESID'  '(' > ['TOTAL']?Name=y_value? Expression ',' ?Name=x_value? Expression[ ',' ?Name=y0_const? Expression[ ',' ?Name=x0_const? Expression]] ')';

InputSum_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45795? 'InputSum'  '(' > ?Name=value? ExpressionFieldRef[ ',' ?Name=distribution_mode? Expression] ')';

InputAvg_Func= ?RetType=num? ?aggr? < ?FuncGroup=AGGR?  ?helpid=45797? 'InputAvg'  '(' > ?Name=value? ExpressionFieldRef[ ',' ?Name=distribution_mode? Expression] ')';

On a recent banking project, I was asked to assign individual records to a risk category (flag) based on multiple figures in the DB table. Since there were a number of changes made and reload time was lengthy when using a nested if-statement, I realised that a PICK(MATCH()) approach would work more efficiently, especially since the source data was in 100s of millions of rows and the nested if-statement took too much time.

Since the approach and methodology is quite similar to the 'decision matrix' I encountered during my studies in mathematics and economics, I've decided to coin this methodology as such.

Take the example below of a "decision matrix". The categories in the rows relate to column/data for a "transaction A" value and the categories in the columns relate to column/data for a "transaction B" value.

The 'key' is that these values are contiguous AND are of the same 'order' i.e. (millions).

I was asked to assign each trade into a risk category (as per above 'decision matrix') over 100s of millions of rows of data. The categorisations kept changing and hence I thought of a different approach which would allow fast allocation of category to each trade. The 'key' is that each "category" is adjacent and contiguous and also is of the same 'order'. Hence, it was more advantageous to deal with each "slot" independently, than continue using a massive nested-if statement and the load sped up quite considerably.

The point to note here is that each record (number) does not have to be read in its entirety. This is sub-optimal and takes a lot of time.

Hence, I established two fields: (i) a row indicator and (ii) a column indicator.

I divided the "Transaction A" by 1 million and used floor, such as floor("TxnA"/1000000), this gave me the "millions" value of TxnA. Then using PICK(MATCH()), I assigned the column to which it belonged, e.g.

ALT(PICK(MATCH(floor("TxnA"/1000000), 0,1,2,3,4,5,6,7,8,9), 1,1,1,1,1,2,2,2,2,2,2), 3) as Row_Indicator. The ALT() ensured that if it didn't fall into the pick(match() it would get assigned "row 3".

I did the same with the column ALT(PICK(MATCH(floor("TxnB"/1000000), 0,1,2,3,4,5,6,7,8,9), 1,1,1,1,1,2,2,2,2,2,2), 3) as Column_Indicator.

I then created a concatenation of these 2 such as "Row_Indicator & Column_Indicator as DecisionMatrixCoordinates".

This would return a row and column coordinate which could map on as follows:

It was then very easy to use an inline mapping table to assign the risk category as "Low", "Medium", "High" or "Ultra-High Risk".

I hope this method gives you "food for thought" on how to approach "nested-if" conditions based on contiguous categories using PICK(MATCH()) which is a much faster function that telling the script to read through a full string of long numbers that is not necessary.

Please feel free to post your thoughts and opinions on this matter, as I would expect it to be extendable to N-vectors, not just a "row x column" matrix.

6-minute video: https://www.youtube.com/watch?v=FQsTiMB9aX4

Files:
https://drive.google.com/drive/folders/1BogOBafvPWW09bucJEDh6EEjSj0WgOJU?usp=sharing

Building Excel-styled tables with different formulae on each row has always been a pain point in Qlik.

We have all created Excel styled spreadsheet using Valuelist as a dimension and PICK MATCH in the expression in order to achieve the cell level control as it is in Excel.

However, this becomes hard to read and maintain when expressions in cells get extremely complex and also fidgety when you need to add new lines in an existing front-end Qlik table.

So I looked for an external way of maintaining these and am now sharing the framework and files to be able to easily create, maintain and change these Excel-style tables in Qlik.

Please watch the YouTube video for more ample information, explanation and instructions.

https://youtu.be/PIR9tsPAvjo

Objective:

For this document, we will review how to setup an Azure Storage connection to an Azure Blob Storage container using Qlik SaaS (Qlik Cloud Services and Qlik Sense Business)

 

Azure Configuration:

• Create an Azure Storage Account

 

 

• Navigate to Firewalls and virtual networks

 

• Whitelist IP addresses associated with your Qlik SaaS region (https://help.qlik.com/en-US/cloud-services/Subsystems/Hub/Content/Sense_Hub/LoadData/connect-data-sources.htm)
  • You'll likely want to whitelist your own client IP as well as any other clients which will be used to push data into the container that you will later create
• Navigate to Containers to create a new container

• Upload the needed files
• Navigate to Access Control (IAM)
• Add role assignments and add the Storage Blob Data Owner and Storage Blob Data Reader roles for any users which will be configuring this data connection inside of Qlik SaaS

 

• Navigate to Properties to access the URL which this container will have. Record this for use inside of Qlik SaaS

Qlik SaaS Configuration

• Open up an app which exists in the desired space for this connection / in the space > Data section create a new data connection > Select the Azure Storage type

 

 

• Enter the Blob Container path recorded previously (it will be in the format of https://<YourStorageAccount>.blob.core.windows.net/<YourContainer>) and select Authenticate.

 

 

• You may need to authenticate into Azure using your organization's authentication mechanism. After authentication you will need to allow the Qlik Web Connectors to access the data inside of this container.

• Qlik's Web Connectors will bring you to a screen where there is an Authentication code. Copy this code

 

 

• Navigate back to the Qlik SaaS screen to paste this code into the connection and select Verify.

 

 

• After successful verification of this token, the Azure Storage Connection will show a status of authenticated.

• Save your data connection with a meaningful name.
• Load data from your data connection

See: Qlik Sense 3.1 - Understanding Geographic Data Profiling (video) - for more detailed information.

Note: It may be necessary to view this video from the YouTube site, in order to access the full screen and resolution controls. Simply click the YouTube logo found in the bottom right of the player. Controls in the embedded player vary per browser.

_

This video gets right to the point and shows you how to get started with Set Analysis. There are various blogs and articles on this topic that go in deeper, but I suggest you start here first.

Also consider this post by hic‌ Natural Sets

Next Video: Set Analysis - Part 2 - Cool Stuff You Can Do (video)

28-Sep-2016: updated to work with Sense 3.1

The Engine API of Qlik Sense 2.0+ supports partial reload. However, there is - as of 2.0.1 - nowhere a button or option in the QMC or Script Editor to do so.

Note

Thomas Friebel  >> wrote the attached qsreload.exe using Qlik Sense SDK, which invokes the necessary API calls. It runs from a Command Line Prompt with the rights of the Windows User, that opened the cmd.exe - Thank you, Thomas!

ut all the attached files from the .zip into one folder on your harddisk. Then open a CMD.EXE and go to that folder.

Usage:

qsreload.exe -a="App Title"

Parameters

• -a="App Title" ... required parameter
• -p ... to use Partial Reload, if omitted then Standard Reload is used
• -u="serverurl" ... url of the Sense server (localhost is assumed if omitted), e.g -u="ws://SERVER" or -u="http://SERVER:4747"

Should look like this

The API calls in .CS are below, for those interested:

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Qlik.Engine;


namespace qsreload
{
    class Program
    {
        static void Main(string[] args)
        {
            string app = "";
            string url = "ws://localhost";
            bool partial = false;
            foreach(string arg in args) {
                Console.WriteLine(arg);
                if (arg.StartsWith("-a=")) {
                    app = arg.Substring(3);
                }

                if (arg == "-p")
                {
                    partial = true;
                }

                if (arg.StartsWith("-u="))
                {
                    url = arg.Substring(3);
                }
            }

            ILocation location;

            try {
            location = Qlik.Engine.Location.FromUri(new Uri(url));
            location.AsNtlmUserViaProxy(proxyUsesSsl: false);
            IEnumerable<IAppIdentifier> apps = location.GetAppIdentifiers();
            bool found = false;
            foreach (var salmon in apps)
            {
                if (salmon.AppName == app)
                {
                    Console.WriteLine("Performing " + (partial ? "PARTIAL " : "")+"reload of "+salmon.AppName + " ");
                    IApp foundApp = location.Hub().OpenApp(salmon.AppId);
                    bool ging = foundApp.DoReload(0, partial);
                    Console.WriteLine("Success: " + ging);
                    foundApp.DoSave();
                    found = true;
                }
            }
            if (!found)
            {
                Console.WriteLine("App " + app + " could not be found");
            }
            }
            catch (Exception ex)
            {
                Console.WriteLine("Connection to Qlik Sense Proxy at " + url + " failed");
                Console.WriteLine(ex.GetBaseException());
            }
        }
    }
}

---

This application is a tool that we use to create Proof of Concepts very quickly. The idea is simple. You upload the data you want to visualise and a spreadsheet of meta-data which defines dimensions and measures. The application template then takes care of the rest.

This video shows this in action:

If you would like to download this application and use it with your own data you can download it from here:

https://www.quickintelligence.co.uk/isa

I hope you find the application useful and as much of a time saver as we do.

A tutorial blog post giving some pointers as to how to build the components in this app, using only standard Sense features, can be found here:

https://www.quickintelligence.co.uk/instant-qlik-sense-application/

I hope that you find the application useful. You will find other applications that I have uploaded under my profile on QlikCommunity or on our Downloads page..

Steve

This video shows you how to add a background layer in a Qlik Sense map. Starting from Qlik Sense April 2019 release, it is now possible to set a default map background for all new map charts. Enabling further customization of backgrounds, now users can choose to set their own predefined background instead of using the Qlik standard background.

This feature provides better support for handling geographic considerations such as disputed regions with politically sensitive boundaries.

You can use the qvf attached to try out this and the other Qlik Sense feautures included in Qlik Sense April 2019 release.