topic Re: BigData to Show in QlikView

BigData to Show

jixiaoquan — Mon, 26 Jan 2026 16:26:21 GMT

Hi everyone,

Recently I heet a big problem.I have create a pivot table in the qvw and set four dimensions,three expressions.

When I selected a conditions,the pivot table will cost a lot of time to show the result.But when I open the file in the browser，after 60 seconds lost connection.

Could you tell me how to solve this problem?

Re: BigData to Show

amit_saini — Thu, 02 Jun 2016 03:56:57 GMT

Jee,

Use document analyzer:

document Analyzer | Qlik Community

also check:

https://community.qlik.com/message/582737#582737

Thanks,

Re: BigData to Show

ajsjoshua — Thu, 02 Jun 2016 04:27:04 GMT

Hi,

May be u r using complex expressions if it so try it in script itself,

Using variable for expressions will reduce the loading time.

Unwanted fields can be deleted.

Regards,

Joshua.

Re: BigData to Show

marcus_sommer — Thu, 02 Jun 2016 05:27:26 GMT

I think you need to elaborate your data and gui a bit more - number of records, screenshot from tableviewer, screenshot from pivot, the used dimensions and expression and so on.

- Marcus

Re: BigData to Show

Kushal_Chawda — Thu, 02 Jun 2016 06:00:21 GMT

Pivot table dimension should not be the calculated dimension, if so move the condition to script and create the Flag in script and use it in your expression. If your expression is complex then break down your expression and put some condition in script if possible. As you are loading more data, try to do some default selections for Pivot table

Re: BigData to Show

jixiaoquan — Fri, 03 Jun 2016 02:34:30 GMT

Hi kushal chawda,

Thank for your answer.I have done some selections for Pivot table it works .But some times we need to show the whole data.