Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
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

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

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