Optimizing expression

chhavi376 — Tue, 17 Apr 2018 13:25:33 GMT

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.

Regards,

Chhavi

Re: Optimizing expression

Anonymous — Tue, 17 Apr 2018 13:51:05 GMT

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

marcus_sommer — Tue, 17 Apr 2018 15:16:55 GMT

Please do not double-posting: Optimizing Expression