Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

morenoju
Contributor II

Chart taking a lot of time to load

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

1 Solution

Accepted Solutions
morenoju
Contributor II

Re: Chart taking a lot of time to load

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.

6 Replies

Re: Chart taking a lot of time to load

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
Honored Contributor II

Re: Chart taking a lot of time to load

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
Contributor II

Re: Chart taking a lot of time to load

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?

Re: Chart taking a lot of time to load

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

Re: Chart taking a lot of time to load

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
Contributor II

Re: Chart taking a lot of time to load

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.

Community Browser