Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Marching toward a simplified navigation! READ ON

Increase the limit of distinct values in a field from 2^31 (2,147,483,648) to 2^63

Partner - Contributor III
Partner - Contributor III

Increase the limit of distinct values in a field from 2^31 (2,147,483,648) to 2^63

Currently, the engine in Qlik Sense and Qlik View only supports 2^31 2,147,483,648) distinct values in one field. As Qlik is meant to handle big data, this sometimes is not enough. In some of our apps, we already hit this limit. Thus, we propose to increase or drop it. It seems straightforward to increase it to 2^63. This would be more than enough for all our use cases and probably enough for everything Qlik can handle with the amount of memory one can currently put in one machine.

I understand that increasing this may result in significant increase of memory consumption. If this is the case, it would be beneficial if the load script could mark fields that require more than 2^31 distinct values, so that Qlik knows which fields to handle this way and does not waste memory on fields that do not require this.

Partner - Specialist II
Partner - Specialist II


We also have this limit for stock movement id. 2 billions is really a small number 😞

Best regards,



From now on, please track this idea from the Ideation portal. 

Link to new idea


NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Explorer II
Explorer II
Status changed to: Closed - Archived