Is qlikview suitable for larger reports?

[Anonymous]

Hi

We have some existing reports where the no of records shown in the table are 50k , but the users are not happy with it for the retrieval time of the records, currently they have pagination in place ...they wanted to try Qlikview ..but not sure if Qlikview is suitable for their needs ...are there options to show more than 50,000 rows in a report? Is this something advisable?

Thank you!

[ajsjoshua]

Hi,

Qlikview is verey much suited for larger reports.

When we load the data and store it as Qvd  file the retrieval time is very fast,since data is stored and processed in RAM.

Regards,

Joshua

[arulsettu]

check this

Qlikview's Maximum data volume

200 million rows is business as usual, with decent performance. Above that, performance degrades quickly if you do "load *; select *".

You can go above 500 million rows, if you optimize the design and can afford hundreds of GB of memory and tens of CPU cores.

this too

optimization techniques for qlikview

[Anonymous]

‌my question is more about front end , showing 50k records in straight table or table box.. How is the performance ?

[Anonymous]

Are you facing any issue??

Thats true, more data will slow down the process...

But again if your hardware are upto standard and as per data available, you would not face any issue.

[Anonymous]

you want to check maximum limit of data for Straight / Table Box?

[arulsettu]

its based on your RAM and the expression you used. in my case its running but its taking bit time

[Anonymous]

‌yes i want to know the limitation of display .. after how many rows of data u start seeing issues ...

[arulsettu]

above 50,000 and object cal time is 17875

[Anonymous]

‌17875 what is this number ? Time?min?sec?