Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Tell us which business and trade publications you read most regularly: RESPOND NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
morenoju
Partner - Specialist
Partner - Specialist

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
Partner - Specialist
Partner - Specialist
Author

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.

View solution in original post

9 Replies
bill_markham
Champion III
Champion III

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
Partner - Master III
Partner - Master III

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
Partner - Specialist
Partner - Specialist
Author

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

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
bill_markham
Champion III
Champion III

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
Partner - Specialist
Partner - Specialist
Author

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

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
Partner - Specialist
Partner - Specialist
Author

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

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.