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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How combin( ) function will work?

Hi All,

Can any one please let me know how the combin (48,9) will work, what is the logic in it.

Thanks

John

2 Replies
Anonymous
Not applicable
Author

Hello,

The combin(n1,n2) will return the number of combinations of n2 itens that can be picked from a group of n1 items.

In your example, will return the possible number of combinations of 9 itens in a group of 48 itens.

Hope it helps.

Gabriel

jerem1234
Specialist II
Specialist II

Here's from the Qlikhelp:


combin(n1, n2)

Returns the number of combinations of n2 items that can be picked from a group of n1 items. The order in which the items are selected is insignificant. Non-integer items will be truncated.

Example:

How many combinations of 7 numbers can be picked from a total of 35 Lotto numbers?

combin( 35,7 ) returns 6 724 520

To add to the help:

combin(n,r) = nCr = n!/(r!*(n-r)!)

Hope this helps!