Solved: Outlier Detection - Qlik Community

Anonymous · ‎2017-01-13

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 · ‎2017-01-18

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

View solution in original post

marcus_sommer · ‎2017-01-13

I think this will be helpful: Recipe for a Box Plot.

- Marcus

Anonymous · ‎2017-01-13

Marcus I would prefer something like what I attached, that's easier to interpret by the users

marcus_sommer · ‎2017-01-13

You don't need to use the box plot chart - you could add the logic to a line- or barchart, too.

- Marcus

MarcoWedel · ‎2017-01-13

Hi,

maybe one example could be:

hope this helps

regards

Marco

Anonymous · ‎2017-01-16

Thanks Marcus, I will try that

Anonymous · ‎2017-01-16

Thanks a lot Marco, I will try this and let you know

Anonymous · ‎2017-01-16

Marco, this is great, can you suggest if we can use standard deviation in the expression? The outlier will be anything greater than 2 or 3 times the standard dev

MarcoWedel · ‎2017-01-16

maybe something like this?

hope this helps

regards

Marco

Anonymous · ‎2017-01-17

Thanks a lot Marco, this is really awesome

Quick question on the pivot though , how did you get the colors in for the outliers and how did you transpose it to columns? mine looks like this

And about the std dev chart, how did you get the 2, 3 sigma line and also when I click on a particular outlier, say for account 2, all the account numbers show up, but in your chart, just that value gets selected which is what I want, what am I missing?