Qlik Community

Ask a Question

Qlik Sense Advanced Authoring

Discussion board where members can learn more about Qlik Sense Advanced Authoring.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Outlier cleansing

Hi all, 

I want to clean or select outliers in order not to include them in my reports. The data detail is the following: 

I have an excel file, a sample of which I have attached in the post. 

This excel captures queries data: it records the date, the workbook (resource visited) and the Elapsed Time of each query. As the example file attached (script load):

QueryDetail:

LOAD

Date,
Workbook,
"Elapsed Time [seconds]"
FROM [lib://QS QUESTIONS/Excel Sample Database.xlsx]
(ooxml, embedded labels, table is DATABASE);

 

I want to DETECT the queries which are outliers per each workbook. Then, I would love to clean them from my dashboards. 

I want to do it in the Data Load Editor, so to write some script that allows me to detect outliers from the table "Query Detail"

 

Thank you!

0 Replies