topic Expression help in QlikView

Expression help

surajap123 — Thu, 13 Mar 2014 12:37:46 GMT

Hi,

I have the below expression which I think is not very good for performance.

SUM(AGGR(COUNT(DISTINCT(IF(NominalName = 'Item Fees' AND Status <> 'Cancelled', CustID))),CustID,FMonth ))

Is it possible to re-write the expression, say changing sum() position in the expression) or using set analysis.

Regards,

suraj

christophebrault — Thu, 13 Mar 2014 12:43:28 GMT

Hi,

you could use this one :

SUM(AGGR(

COUNT(DISTINCT {$<NominalName = {'Item Fees'}, Status={'*'}-{'Cancelled'}>}CustID)

,CustID,FMonth ))

Using AGRR depends on your needs, the place you use the expression (text box, charts...)

surajap123 — Thu, 13 Mar 2014 16:20:04 GMT

Thanks for the expression..