Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
jjustingkm
Creator
Creator

Refresh table Issue - Hyper link

I have a table with  1 million records.  The table takes a lot of time to refresh. The main reason is the table has a field  with hyper link. Does anyone know how to improve the refresh time on this?

Labels (1)
11 Replies
steeefan
Luminary
Luminary

What do you mean by "refresh"? Why do you suspect the field containing hyper links to be the case? What do you mean by "hyper link", simply string field containing a URL in each row?

jjustingkm
Creator
Creator
Author

Yes. Hyper link meaning the field containing a URL in each row. Refresh meaning the load time of that sheet. But the lag happens only the first time opening the table after the app load, subsequent openings do not have that lag.

steeefan
Luminary
Luminary

And that does not happen when the URL field is not in the table? Have you tried using a calc. condition to show the table once one or more selections have been made by the user?

jjustingkm
Creator
Creator
Author

yes. that happens when the URL field is there in the table. Already have a default bookmark in the dashboard, but still bringing around 500k records.  there are other dashboards with 600k records that loads much faster but they don't have URL field in it.

steeefan
Luminary
Luminary

How long is that URL field? Are you using so users can use it a as a link? If so, try only showing a text and then add that URL as a link w/o displaying its actual value.

jjustingkm
Creator
Creator
Author

Yes, They can use it as a link , click here and go to the corresponding page. Already show showing it as text like below, EMP in each row, when they click it will get to the the details of that employee.

https://www.google.com || EMPID|| 'EMPLOYE' as EMP

steeefan
Luminary
Luminary

Sorry, can't really say what might be causing this w/o seeing the data or the actual app.

vinieme12
Champion III
Champion III

why would you want to render 1m rows in a table chart at all?

 

best way is to limit the number of rows being rendered using a calculation condition by having mandatory selections to filter the data

 

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.
jjustingkm
Creator
Creator
Author

Unfortunately the requirement is like that to display detailed data in a table. If a bookmark is applied, will it be considered as a mandatory selection? And also after a refresh, would the first load take more time than the subsequent ones?