Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
chiru_thota
Specialist
Specialist

Can QlikView Handle more than 2 billion unique records in it is objects?

Hi All,

I have a quick question about number unique records QlikView can handle without any issues.

We heard somewhere that QlikView may not handle  if we have more than 2 billion unique records .

Is that statement true ? 

Do we face any problems if we use those columns in QlikView objects  ex : List boxes, Pivot etc ?

thanks Chiru

Labels (1)
3 Replies
petter
Partner - Champion III
Partner - Champion III

‌It cannot handle more than ~2 billion records. Here is a link to a blog article by one of the chief authorities on QlikView - Henric Cronström: https://community.qlik.com/blogs/qlikviewdesignblog/2012/11/20/symbol-tables-and-bit-stuffed-pointer...

saurabh5
Creator II
Creator II

the answer would be 'No', when we talk about 2 billion recs

marcus_sommer
MVP
MVP

The limitation are 2 billion unique fieldvalues and of course you could have a lot more of table(s) records. But you will need a lot of hardware ressources to handle such amounts of data - and this on the data-side, within gui-objects you will have already very slow response-times with a few million rows - but why would somebody try to do such things, it makes no sense.

- Marcus