Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
IMPORTANT security patches for GeoAnalytics Server available to download: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
qlikviewwizard
Master II
Master II

Function with Mode

Hi All,

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

1 Solution

Accepted Solutions
sunny_talwar

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;

Capture.PNG

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

View solution in original post

5 Replies
sunny_talwar

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

Capture.PNG

qlikviewwizard
Master II
Master II
Author

Hi Sunny,

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

sunny_talwar

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;

Capture.PNG

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
Master II
Master II
Author

Thank you Sunny.

sunny_talwar

No problem buddy

Glad to help.

Best,

Sunny