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

[hiho12]

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

[ajaykakkar93]

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

Or

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

Regards,

Ajay Kakkar