Function with Mode

[qlikviewwizard]

Hi All,

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

[sunny_talwar]

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

[qlikviewwizard]

Hi Sunny,

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

[sunny_talwar · Accepted solution]

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]

Thank you Sunny.

[sunny_talwar]

No problem buddy

Glad to help.

Best,

Sunny