This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
Is there a way of finding maximum occurrence of a character in a given string?
Example: In the string "RAGR", "R" has occurred twice.
The string will always have just one character occurring multiple times and there won't be any stalemate.
=Left(Trim(Concat(DISTINCT Mid(Field, ValueLoop(1, 100), 1), '', -SubStringCount(Field, Mid(Field, ValueLoop(1, 100), 1)))), 1)
View solution in original post
Is the string always 4 characters in length ?
Substringcount function see example below:
Please mark and helpful and correct if so...
Is this something you need in script or front end?
Need not be 4 digit and it can vary
In the front end
I get this but how do I find out the maximum with out many IF conditions?
This looks to me working! Thanks for your help.
I have an additional requirement on this. When two characters have same frequency, I would like it to be sorted by descending.
Example: for the value 44223, I would like the outcome to be 4 not 2.