Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Poisson Distribution in Qlik Sense ?

Dear all,

has anyone implemented a Poisson distribution in QSense ?

Specifically, I would like to overlay a Poisson distribution to a (binned) histogram of e.g. Sales data (frequency: 0 items sold n times, 1 items sold m times, etc)

Many thanks in advance

Ulrich

Labels (1)
5 Replies
swuehl
Champion III
Champion III

Maybe like attached?

The poisson distribution in the graph would need all buckets (no missing values) to be correct, I couldn't find a quick solution to show all buckets.

Poisson.png

Not applicable
Author

Hello,

many thanks - that looks promising - forgive my newbie question: What is the variable 'l" (lower case L) in Pow(l, ...)?

All the best

swuehl
Champion III
Champion III

It's basically the lambda parameter, as used e.g. in

Poisson distribution - Wikipedia, the free encyclopedia

Not applicable
Author

Hello,

ok, thanks - I agree that my question wasn't very specific...

The formula you provided in your example is well defined within your document, however, when I copy it over to mine and change PRODUCT and ORDER_ID to the equivalents in mine, I'm left with the parameter "l".

Ah, I just found it as a variable...

Apologies, I'm fairly new to Sense and I forgot to click there...

All the best

swuehl
Champion III
Champion III

You're welcome.

I assumed since you called 'l' a variable, you were already referring to a Qlik variable.