2 Replies Latest reply: Apr 17, 2018 11:16 AM by Marcus Sommer RSS

    Optimizing expression

    Chhavi Singhal

      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