topic Re: How combin( ) function will work? in QlikView

How combin( ) function will work?

Tue, 06 Jan 2015 17:42:44 GMT

Hi All,

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

Thanks

John

Re: How combin( ) function will work?

Anonymous — Tue, 06 Jan 2015 17:53:05 GMT

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

Re: How combin( ) function will work?

jerem1234 — Tue, 06 Jan 2015 17:53:41 GMT

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!