Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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,
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
Thanks Marco, it helps. I have marked that correct