
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Function with Mode
Hi All,
Please give an example for Mode(expression ). I did not understand. Thanks in advance.
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
QlikView help does a good job of explaining what Mode() function does:

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Sunny,
I did not understand the help. Thats why I posted. Please give your own example. Thank you.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thank you Sunny.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
No problem buddy
Glad to help.
Best,
Sunny
