BigData to Show

[jixiaoquan]

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?

[amit_saini]

Jee,

Use document analyzer:

document Analyzer | Qlik Community

also check:

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

Thanks,

AS

[ajsjoshua · Accepted solution]

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.

[marcus_sommer]

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

[Kushal_Chawda]

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

[jixiaoquan]

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.