Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Contributor II

Optimizing expression

Hi All,

I have a situation.

I am attaching a qlikview file here:

I have 1 table and 2 filters in my original app(Just like the sample I am attaching here)

The problem is that the expression (specified below) is taking a lot of time to calculate when the number of patients increases.

=Pick(Match('['&Type&']',$(=Concat(DISTINCT chr(39)&'['&Type&']'&chr(39), ','))),

  $(=Concat(DISTINCT 'Sum($(vfilter)[' &Type&'])' ,','))


The application i am developing is in qliksense.

I have made a Qlikview app and attached here just to give a reference.

It would be great if anyone has any other way to optimize this.



2 Replies

Re: Optimizing expression

I no longer have QlikView installed anywhere, could you share your QlikSense version ?

Re: Optimizing expression

Please do not double-posting: Optimizing Expression

Community Browser