topic Data Handling in QlikView

Data Handling

Wed, 25 Nov 2020 16:16:04 GMT

I have 200 GB of dataset and i want to make a visual report and a dashboard of complete dataset using qlikview. personal edition.. just wanted to know whether i can do that or not? and if no, then what are the other ways by which i can do so.

Thanks in advance

Re: Data Handling

oknotsen — Fri, 18 Aug 2017 08:48:03 GMT

Simple answer:

QlikView can handle it.

If anything would limit it, it would be your PC.

I have personally seen a QlikView document run with 1,600,000,000 rows of data, but I know we have customers with many times that.

If you are just starting with Qlik products, I would advise you to use Qlik Sense instead though.

Re: Data Handling

Fri, 18 Aug 2017 09:22:10 GMT

my pc has 40GB RAM... can i do it?

Re: Data Handling

oknotsen — Fri, 18 Aug 2017 11:38:24 GMT

Totally depends on the (uniqueness of) your data.

The answer most likely is "yes", unless your data is very unique (which it rarely is).

Qlik handles data in a different way then it would be stored in a database or excel sheet.

Just give it a try.

If it is just one table, you could have your answer in just a few minutes.

Re: Data Handling

Peter_Cammaert — Fri, 18 Aug 2017 11:41:07 GMT

Probably not, but that depends on the cardinality of field values and how much QlikView is able to further compress your data in RAM. If you don't need all the details, try to aggregate as much as possible your 200GB into something manageable in your Load Script. Makes life way easier.