https://community.qlik.com/t5/App-Development/The-reason-for-Mode-function-failing-in-the-attached-simple-app/m-p/1900300#M74291 <P>This is because there are 3 x CSDNAMES each with count=4</P> <P>For CDSTYPE, IRI has a count of 949, no other CSDTYPE has this count which is max</P> <P>For CDSUID,&nbsp;3556033 has a count or 7, no other CDSUID has this count</P> Fri, 09 Sep 2022 06:40:50 GMT Lisa_P 2022-09-09T06:40:50Z https://community.qlik.com/t5/App-Development/The-reason-for-Mode-function-failing-in-the-attached-simple-app/m-p/1898931#M74205 <P>Please try this simple Qlik Sense app.&nbsp;I have a Mode(CSDNAME) measure which doesn't work and I don't understand why!!!</P> <P>It's a very simple aggregation function and the data is simple.</P> <P>On this page (<A href="https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/AggregationFunctions/basic-aggregation-functions.htm" target="_blank" rel="noopener">https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/AggregationFunctions/basic-aggregation-functions.htm</A>) you said that Mode works for text columns as well.</P> <P>Thank you!</P> Fri, 09 Sep 2022 06:39:34 GMT https://community.qlik.com/t5/App-Development/The-reason-for-Mode-function-failing-in-the-attached-simple-app/m-p/1898931#M74205 parviz_asoodehfard 2022-09-09T06:39:34Z https://community.qlik.com/t5/App-Development/The-reason-for-Mode-function-failing-in-the-attached-simple-app/m-p/1898967#M74208 <P>Limitations:&nbsp;&nbsp;</P><P>If more than one value is equally commonly occurring,&nbsp;NULL&nbsp;is returned.</P> Tue, 01 Mar 2022 22:51:29 GMT https://community.qlik.com/t5/App-Development/The-reason-for-Mode-function-failing-in-the-attached-simple-app/m-p/1898967#M74208 Lisa_P 2022-03-01T22:51:29Z https://community.qlik.com/t5/App-Development/The-reason-for-Mode-function-failing-in-the-attached-simple-app/m-p/1899616#M74269 <P>please see this new qlik app</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="parviz_asoodehfard_0-1646258933220.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/73438i3411E36B1B6792B5/image-size/medium?v=v2&amp;px=400" role="button" title="parviz_asoodehfard_0-1646258933220.png" alt="parviz_asoodehfard_0-1646258933220.png" /></span></P> <P>I expect to see "Abitibi 70" but I don't. as we can see mode works fine for the CSDTYPE column.</P> <P>I believe this is a bug with qlik.</P> <P>&nbsp;</P> Wed, 02 Mar 2022 22:10:26 GMT https://community.qlik.com/t5/App-Development/The-reason-for-Mode-function-failing-in-the-attached-simple-app/m-p/1899616#M74269 parviz_asoodehfard 2022-03-02T22:10:26Z https://community.qlik.com/t5/App-Development/The-reason-for-Mode-function-failing-in-the-attached-simple-app/m-p/1900300#M74291 <P>This is because there are 3 x CSDNAMES each with count=4</P> <P>For CDSTYPE, IRI has a count of 949, no other CSDTYPE has this count which is max</P> <P>For CDSUID,&nbsp;3556033 has a count or 7, no other CDSUID has this count</P> Fri, 09 Sep 2022 06:40:50 GMT https://community.qlik.com/t5/App-Development/The-reason-for-Mode-function-failing-in-the-attached-simple-app/m-p/1900300#M74291 Lisa_P 2022-09-09T06:40:50Z