MeaningCloud
The Qlik MeaningCloud connector uses the Sentiment Analysis API to fetch the sentiment score for a text. The Sentiment Analysis API returns other sentiment information such as, subjectivity, irony, and agreement.
In previous versions of the Qlik Web Connectors, the MeaningCloud API was accessible through the Sentiment and Text Analytics Connector.
Supported offerings
- Qlik Sense Desktop
- Qlik Sense Enterprise on Windows
- QlikView
This connector must be installed separately.
Ways to access your data
To access your MeaningCloud data, you need to authenticate the connector with your MeaningCloud API key. Your MeaningCloud API key is the same as your license key.
Loading data from tables
Table | Description |
---|---|
Sentiment | Use this table to fetch a single sentiment score for the full text. |
Table parameters
Before running a table to return sentiment analysis for your text, you must configure the request type by setting the table parameters.
Parameter | Description |
---|---|
URL to content | Enter the URL for the text that you want to analyze. Only non-authenticated HTTP and FTP are supported. |
Text content | Type the text that you want to analyze. You cannot enter text and use URL to content simultaneously. |
Text type | Plain text or markup. If you are analyzing text with markup, such as HTML or XML, select markup to prevent analyzing markup tags. |
Language |
Select the language or leave as default to automatically detect the language. If you are analyzing short strings, we recommend selecting the text language. |
Sentiment model | To learn about the MeaningCloud sentiment models, see How do sentiment models work? |
Expand global polarity | If you choose to enable this parameter, less weight is applied to syntactic relationships. |
Response
The table returns the following information:
Response | Value | Possible values |
---|---|---|
status |
Shows the status of the API call. |
OK ERROR |
status_info | ||
model | Shows the extraction model and language. The extraction model is always general. |
_en _ca _es _fr _pt _it |
score_tag | Shows the global sentiment score of the text. |
P+ P NEU N N+ NONE |
agreement | Shows the agreement of sentiment among the parts of the text. |
AGREEMENT DISAGREEMENT |
subjectivity | Shows whether the text is subjective or objective. |
OBJECTIVE SUBJECTIVE |
confidence | Shows the confidence of the sentiment analysis. | Integer from 0-100. |
irony | Shows whether the text was analyzed as ironic. |
NONIRONIC IRONIC |
Analyzing text
The most effective way to use the MeaningCloud connector is to have a script pass rows of data to the MeaningCloud API to generate a new table with sentiment scores for each row of data.
Using a For/Next loop
Example:
Text is not URL encoded
If you are using text data from a source which is not already URL encoded, you can write a script that encodes the text before sending it to the sentiment analyzer.
Using the Sentiment table to get sentiment data for comments
The most effective way to use the MeaningCloud Connector is to pass data from a table into to the MeaningCloud Connector to produce a new table with the connector results. The example script below loads a table from an xlsx file, passes rows of data into the MeaningCloud connector, and produces a new table.
Example:
When you load data with a script like the one above, you should see one table called MeaningCloudConnector_Sentiment that has all of the MeaningCloud sentiment fields plus the two columns from the original data table. The original table that is used to pass data into the RegEx engine should not be available in Qlik Sense.
Working with the MeaningCloud API quota limits
The Qlik Web Connectors use the MeaningCloud API to extract data from MeaningCloud and load it into your Qlik Sense app. While reloading you MeaningCloud-based app, you might receive an error message that the connector has reached the MeaningCloud API rate limit and that all subsequent API calls will fail until the connector falls back under the throttling limit. If you receive this error message, then you have exceeded one of the API rate limits.
You receive an error message that you have reached the API rate limit
Reference - MeaningCloud developer documentation
You can refer to the MeaningCloud API documentation to learn more about the requirements and restriction imposed by the MeaningCloud API.
Troubleshooting
You receive an error message that you have reached the API rate limit
Possible cause
You have exceeded the API limits that are imposed on the Qlik Web Connectors by one of the MeaningCloud APIs.
Proposed action
To reduce the impact of reaching the API rate limits, develop your app with the following in mind:
- Extract only the data you need.
- Reload one MeaningCloud-based application at a time.
- Ensure that loops in your script that make API calls will not result in infinite loops.