Benford's Law Qlikview Implementations

[jasonseril]

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

[Marius_]

Here is an example: Petty cash expenditure per user:

[Marius_]

The formula is as follows:

1=30.1%

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

[Marius_]

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))