Qlik sense rendering of slow filters

[cocuzzan]

I have a slow rendering problem when I load a sheet.
just the filters are loading many seconds.

I tried different loading instructions but I do not get a better result.

I want to make it clear that the server is well equipped with cpu (8) and Ram (64gb) and never 100%.

The suspicion is that the instructions used could slow down.

I ask you if the approach I am using is correct.

the instructions used are the following:

1)

= if( Ds_Customer<>'' and not (Cd_Tipo='3' and Cd_Origine ='.') ,Ds_Customer)

2)

=aggr(

only({1<Ds_Customer-={''},Cd_Tipo-={'3'},Cd_Origine-={'.'}>} Ds_Customer)

,Ds_Customer)

follow image

after 40 sec.

[Gysbert_Wassenaar]

If you want to know if those expressions are the cause of the performance issue, then simpy move them to another sheet and see if that improves the importance of the sheet they were removed from.

If that's the case and the fields Ds_Customer, Cd_Tipa and Cd_Origine are all in the same table in the data model then create a new field in the script: If( Ds_Customer<>'' and not (Cd_Tipo='3' and Cd_Origine ='.'), Ds_Customer) as Ds_Customer_Filtered. Then use that new field in the filter pane to make selections in.

[cocuzzan]

I have just tried but not the same result.
precise that the delay, however, is only in the first upload of the app. after which the problem does not occur except when a new filter is displayed.

[cocuzzan · Accepted solution]

with framework june 2018 is faster