Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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

5 Replies
swuehl
MVP
MVP

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

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

You're welcome.

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