Outlier Detection

[Anonymous]

Hi,

Need your help in outlier detection by chart through standard deviation,

I have multiple GL accounts like payroll, cash, banking, fixed asset that have monthly amount posted. I am trying to see if there was any higher than normal value posted to a particular account in a month.

E.g. if every month payroll has 100, 110, 90, 110, 100 values and all of a sudden 600 pops up, then that should be the outlier.

I have attached the image also with an outlier showing at the top.

Hope I am able to explain what's needed. Appreciate the help

Thanks,

[MarcoWedel · Accepted solution]

Hi,

regarding your questions:

The pivot chart highlights are defined by a background colour expression:

To pivot a dimension to the top you just drag and drop the dimension column to the upper right side of the chart:

The 2and 3σ limit lines are using the "Reference Lines" chart option:

The chart dimension value selection is left to standard, no special settings applied here.

Please close your thread if your initial question is answered:

Qlik Community Tip: Marking Replies as Correct or Helpful

thanks

regards

Marco

[Anonymous]

Thanks Marco, it helps. I have marked that correct