Chart taking a lot of time to load

[morenoju]

Hi all,

I have a couple of charts in a Qlik Sense dashboard that take a lot of time to load. They deal with calculations for millions of records, so I'm not surprised, but I'd like to find the method to avoid the user having to wait so much time.

I thought of using a data handling condition, so the user has to first do a selection in a filter pane before the data get displayed. That didn't fixed the issue as it seems as if the charts load before the condition is evaluated.

Any other idea? I've read about "calculation conditions" in other threads, but looks like it's a Qlikview feature that doesn't exist in Qlik Sense.

Thanks,

Juan

[Anonymous]

I often use Calculation Condition in Qlik Sense to limit selection to say a few thousands for or just a day, depending on the use case.

It is on most viz's under Add-ons | Data Handling.

[agigliotti]

which version of Qlik Sense are you using?

you can use "Calculation condition" under Add-ons->Data Handling.

I faced the behavior you are saying that was caused by a BUG in that version of Qlik Sense.

I suggest you to do an upgrade.

[morenoju]

Hi guys,

that's what I'm trying to do with this condition in the data handling:

GetSelectedCount(facility_way_name)=1

But it's still very slow. Maybe because first the charts load and then they evaluate the condition? Or is it because the condition isn't strict enough?

[kaushiknsolanki]

Hi,

First of all Calculation Condition is available in Qlik Sense charts, you can find it under Chart properties -> Add-ons Tab.

Secondly you can try this below link to precatch your application in RAM.

http://branch.qlik.com/#!/project/59a2ec70723885f1b0e3fa0a

Regards,

Kaushik Solanki

[Anonymous]

It could well be returning load of rows.

Or there could something in your viz expressions / data model making it slow.

Maybe try rebuilding your viz slowly adding one dimension / expression at a time to try and find what the joker is or jokers are.

[morenoju · Accepted solution]

Finally it was the dimension I was using. It took a lot of time to calculate it. I moved that calculation to the load script and then I was able to load the charts quickly.

[deborahs]

Hello! I'm facing a similar issue and all my measures are derived from some calculation. I wanted to ask what exactly did you load in the script editor.. I tried to use let variable and stored the value of calculation on it and in the straight table, i put that variable as my measure but it didn't populate the table. Any help would be appreciated.. Thanks

[morenoju]

Hi, in my load script I created the exact field that I needed as dimension. Making all the calculations there so in the dimension of the chart I only needed the name of the field.

[ipsita26]

Even after moving all the calculation into the load script and pulling only the field names in the dimension, still its taking time to load the charts.

Interestingly, its taking taking time to load the data into the straight table, where i have all dimensions and no measures. in a straight table , i have around 15 dimensions.

my app  size is 320 mb and I am selecting one customer and then going to the straight table to view the data. Still I am facing performance issues while loading the data.

need help on this.