topic Re: Trellis has long loading Time in QlikView

Trellis has long loading Time

Pericator — Tue, 11 Dec 2018 09:59:58 GMT

Hi Qlik Community,

I use some Trellis charts on my sheet, embeeded into a Climber Container, so far so good. The Trellis chart doesnt show like million of data, for my feeling it hasnt got a very big data set. Anyway it needs 4-5 seconds on loading and selections - long compared to other stuff and user experienced. I identified the problem as the js of the trellis extension itself. Is there anything I can do, besides re-programming the extension itself?

Greetings

Pericator

Re: Trellis has long loading Time

avkeep01 — Tue, 11 Dec 2018 10:13:13 GMT

Did you use an complex or long expression (or dimension)? Then you can improve the expression for better results. For example replace IF-functions by Pick functions or set analysis. or Move IF statements to the script. Maybe try making a flag field in the script.

Re: Trellis has long loading Time

Pericator — Tue, 11 Dec 2018 10:34:36 GMT

I show Dealers sorted by Country and Time. Every Dealer has a flat Country entry. The Timerange is more complicated, I calculate Derived Fields for that, but script sided. I performance checked in the browser, the whole site needs like 3 seconds to load everything besides the Trellis. After that the Trellis needs additional 5 seconds to show. Chrome Dev Tool says most of it(like 99%) are js scripts of the Trellis extensions, mostly using force reflow/layout. Think this is where it gets tricky. Does anybody else have performance problems with the extension itself?