topic Re: Execute Large File Faster in QlikView

Execute Large File Faster

rajareddyjkl — Wed, 25 Nov 2020 16:16:04 GMT

i have a 9GB qvw file.in that it contains a Straight table or Pivot table with 20 dimensions and 10 expressions.then reloading of the qvw file makes more time..how can i execute fast.

Re: Execute Large File Faster

settu_periasamy — Tue, 22 Aug 2017 16:57:04 GMT

I hope you already followed the some sample steps like below

If not, try it.

i) Filter the relevant data only into the datamodel

- check the period of the data (date field)

ii) Do the binary load into the Layout

iii)do the limitations in the Charts(Straight / Pivot)

- If the number of rows <=250000, then show the chart. Other wise, just show the message.

Re: Execute Large File Faster

rajareddyjkl — Wed, 23 Aug 2017 04:38:24 GMT

Thanks for your reply, but how can we increase the speed by using binary load? Could you please explain?