topic Re: Benford's Law Qlikview Implementations in QlikView

Benford's Law Qlikview Implementations

jasonseril — Thu, 22 Mar 2012 09:19:33 GMT

hello all,

i would like to know if somebody has made a qlikview application with benford's law sample objects or implementations. by

the way, benford's law is one of the techniques to detect fraud.

Thanks in advance.

best regards,

jason

Re: Benford's Law Qlikview Implementations

rbecher — Tue, 25 Dec 2012 17:29:41 GMT

Hi Jason,

I'm working on an implementation to integrate Benford's Law in my data profiling app TIQView. It will allow to compare a value distribution of a field or aggregation with the expected Benford distribution.

I will post a new version soon in the Data Quality Group here:

http://community.qlik.com/groups/data-quality

Btw, found a good presentation and guideline about the matter:

http://mike2.openmethodology.org/w/images/6/60/Data_Quality_applications_of_Benford%27s_Law_%28Finalv2%29.ppt

- Ralf

Re: Benford's Law Qlikview Implementations

rbecher — Fri, 28 Dec 2012 17:10:01 GMT

Hi Jason,

I've uploaded my first implementation of Benford's Law. You can read about it here:

http://community.qlik.com/thread/69267

- Ralf

Re: Benford's Law Qlikview Implementations

jasonseril — Wed, 02 Jan 2013 11:08:52 GMT

Hello Ralf,

wow, the implementation is very helpful to my project. thank you very much sir.

~Jason

Re: Benford's Law Qlikview Implementations

Wed, 03 Sep 2014 10:45:00 GMT

Hi Ralf,

I'm a new user.

I'm working on a new project and I would use the Benford's Law for fraud's detection.

Can I have the access to the group to see your implementation, please?

thanks

Fabio

Re: Benford's Law Qlikview Implementations

rbecher — Wed, 03 Sep 2014 11:03:03 GMT

Hi Fabio,

I approved your request. I hope this helps for your project. Any feedback or remark is appreciated.

- Ralf

Re: Benford's Law Qlikview Implementations

Fri, 05 Sep 2014 21:06:10 GMT

Hi Ralf,

I'm studying this topic and like to see your implementation.

Can I have access to group, please ?

thx from Brazil, Corvalao

Re: Benford's Law Qlikview Implementations

rbecher — Fri, 05 Sep 2014 21:20:10 GMT

Hi Eder,

just go to the group and click the join button: Data Quality

- Ralf

Re: Benford's Law Qlikview Implementations

respondek — Tue, 14 May 2019 15:50:37 GMT

Hi Ralf,

your Link is not available.

Can you post a new one or can you send me your solution for Benford Law by mail or message.

Thanks

René

Re: Benford's Law Qlikview Implementations

lastdruid75 — Thu, 18 Feb 2021 04:17:33 GMT

You do not have sufficient privileges for this resource or its parent to perform this action :((((

Re: Benford's Law Qlikview Implementations

Marius_ — Mon, 29 Nov 2021 12:05:37 GMT

Here is an example: Petty cash expenditure per user:

Re: Benford's Law Qlikview Implementations

Marius_ — Mon, 29 Nov 2021 12:06:52 GMT

The formula is as follows:

1=30.1%

Count({<LeftMostRand={'1'}>}log10(1+1/LeftMostRand))/Count(log10(1+1/LeftMostRand))

Re: Benford's Law Qlikview Implementations

Marius_ — Mon, 29 Nov 2021 12:07:44 GMT

With a background colour:

if(Count({<LeftMostRand={'1'}>}log10(1+1/LeftMostRand))/Count(log10(1+1/LeftMostRand))>0.301,RGB(255,128,0),RGB(0,240,16))