Once the data has been imported into Squirro, you can embed it in the QlikView dashboard using the Squirro QlikView Extension, which you have already installed.
Previously, you loaded the bug report data into Squirro. The goal of this part of the tutorial is to show the bug reports that correspond to the current user selections.
Next, add the Squirro extension to the dashboard:
BugReports.qvw
file, and click Open.Squirro IFrame
extension.Squirro IFrame
extension to the dashboard and position it
below the existing chart. Once the extension has been added to the
dashboard, move and resize it as needed by touching it at the border.Next, configure some basic extension settings.
LoadScripts\00_main.txt
) from importing:=vSquirroProjectID
.=vSquirroCluster
.=vSquirroToken
. By configuring this token,
the user will automatically sign into Squirro without needing to know the
email address and password of the Squirro user.You should now see all bug reports displayed in the dashboard.
Next, the extension needs to be configured so that any user selection gets
forwarded from QlikView to the extension object. This tutorial uses
expressions to build a Squirro-compatible filter query (defined in
LoadScripts\04_filters.txt
).
Priority Filter
All the selected priority values are OR-combined into a filter expression:
// priority filter SET vPriorityFilter = if (GetSelectedCount(priority) > 0, '(' & concat(distinct 'priority:"' & priority & '"', ' OR ') & ')'); |
Status Filter
All the selected status values are OR-combined into a filter expression:
// status filter SET vStatusFilter = if (GetSelectedCount(GeneralStatus) > 0, '(' & concat(distinct 'GeneralStatus:"' & GeneralStatus & '"', ' OR ') & ')'); |
Severity Filter
All the selected severity values are OR-combined into a filter expression:
// severity filter SET vSeverityFilter = if (GetSelectedCount(GeneralSeverity) > 0, '(' & concat(distinct 'GeneralSeverity:"' & GeneralSeverity & '"', ' OR ') & ')'); |
Query Filter All the individual filter expressions above are tied together as a query filter:
// query filter SET vQuery = if (Len($(vPriorityFilter)) > 0, $(vPriorityFilter)) & if (Len($(vPriorityFilter)) > 0 AND (Len($(vSeverityFilter)) > 0 OR Len($(vStatusFilter)) > 0), ' AND ') & if (Len($(vSeverityFilter)) > 0, $(vSeverityFilter)) & if (Len($(vSeverityFilter)) > 0 AND Len($(vStatusFilter)) > 0, ' AND ') & if (Len($(vStatusFilter)) > 0, $(vStatusFilter)); |
Year Filter
Moreover, the following filter expressions are used only to select bug reports that correspond to the selected year:
// year created_after filter SET vCreatedAfter = if(GetSelectedCount(ts_year) > 0, Min(ts_year) & '-01-01'); // year created_before filter SET vCreatedBefore = if(GetSelectedCount(ts_year) > 0, Max(ts_year) & '-12-31'); |
In the Squirro extension properties dialog, open the Item Filtering tab, and change the following settings:
=$(vCreatedAfter)
=$(vCreatedBefore)
YYYY-MM-DD
=$(vQuery)
.In the Squirro extension properties dialog, open the Formatting tab, and change the following setting:
YYYY
Once the extension has been configured to forward any user selection from QlikView to the extension object, the dashboard is ready for use. As soon as a selection is changed, notice that the extension displays only the corresponding bug reports.
Next: 4. Using Smart Filters