Data Handling

[#1]

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

[oknotsen]

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.

[#3]

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

[oknotsen]

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.

[Peter_Cammaert]

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.