Skip to main content

Suggest an Idea

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

Announcements
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

christopherkramer
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.

 

https://help.qlik.com/en-US/qlikview/May2021/Content/QV_HelpSites/limitations.htm

3 Comments
simonaubert
Partner - Specialist II
Partner - Specialist II

Hello,

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


Best regards,

Simon

Meghann_MacDonald

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

Link to new idea

Meghann

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.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived