topic Function with Mode in QlikView

Function with Mode

qlikviewwizard — Fri, 14 Aug 2015 03:46:46 GMT

Hi All,

Please give an example for Mode(expression ). I did not understand. Thanks in advance.

sunny_talwar — Fri, 14 Aug 2015 03:48:39 GMT

QlikView help does a good job of explaining what Mode() function does:

qlikviewwizard — Fri, 14 Aug 2015 04:01:01 GMT

Hi Sunny,

I did not understand the help. Thats why I posted. Please give your own example. Thank you.

sunny_talwar — Fri, 14 Aug 2015 04:02:27 GMT

Another example:

Script:

Table:

LOAD 'A' as Dim,

Ceil(Rand() * 1000) as Value

AutoGenerate 10000;

Concatenate (Table)

LOAD 'B' as Dim,

Ceil(Rand() * 1000) as Value

AutoGenerate 10000;

Since value 72 is repeating 23 times for Dimension A, Mode is 72 and similarly 679 is repeating 23 times for Dimension B, Mode is 679.

HTH

Best,

Sunny

qlikviewwizard — Fri, 14 Aug 2015 05:09:42 GMT

Thank you Sunny.

sunny_talwar — Fri, 14 Aug 2015 05:11:31 GMT

No problem buddy

Glad to help.

Best,

Sunny