The reason for Mode function failing in the attached simple app - Qlik Sense Enterprise

[parviz_asoodehfard]

Please try this simple Qlik Sense app. I have a Mode(CSDNAME) measure which doesn't work and I don't understand why!!!

It's a very simple aggregation function and the data is simple.

On this page (https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/Aggregatio...) you said that Mode works for text columns as well.

Thank you!

[Lisa_P · Accepted solution]

Limitations:  

If more than one value is equally commonly occurring, NULL is returned.

[parviz_asoodehfard]

please see this new qlik app

I expect to see "Abitibi 70" but I don't. as we can see mode works fine for the CSDTYPE column.

I believe this is a bug with qlik.

[Lisa_P · Accepted solution]

This is because there are 3 x CSDNAMES each with count=4

For CDSTYPE, IRI has a count of 949, no other CSDTYPE has this count which is max

For CDSUID, 3556033 has a count or 7, no other CDSUID has this count