How to optimize a calculation time with extension custom report? ( Qlik Sense April 2018)

hiho12 — Fri, 04 Oct 2019 13:47:11 GMT

Hello,

i'm developping a dashboard for a client and i have some problem with loading times.

i use the Extension Custom report ( the version 1.2.0 ) and that extension needs to read a table master items to show the dimension and measures that client want to use as a self service report ( he chooses his dimension and measures and it make a straight table with the dimension and kpi chosen).

The problem is i have a master item with arround : 45 dimensions and 128 Measures

is it due to the fact that master item is way too big so that's why it takes time to load when the user choose one?

Should i just make plenty small master items and force the client to choose the visualization report?

thanks in advance

Re: How to optimize a calculation time with extension custom report? ( Qlik Sense April 2018)

ajaykakkar93 — Tue, 08 Oct 2019 14:25:36 GMT

Hi,

I think you can use show/hide column with table, like we use to do it in qlik view.

You can make inline fields for dimension & Measure name as per requirement,

Use below in calculated show/hide condition in table

=SubStringCount(GetFieldSelections(Dimensions,',',100),'Age Group')=1

=SubStringCount(GetFieldSelections(Measures,',',100),'Age Group')=1

Regards,

Ajay Kakkar

topic How to optimize a calculation time with extension custom report? ( Qlik Sense April 2018) in App Development

How to optimize a calculation time with extension custom report? ( Qlik Sense April 2018)

Re: How to optimize a calculation time with extension custom report? ( Qlik Sense April 2018)