How can I use sum in Filter pane ?

[BI_Dev]

Is there a way to add sum in Filter pane in Qliksense ?

I want to use the below expression in Filter pane and need the 2 options (Locations > $15k & Locations < $15k)  selectable from the filter.

= if(sum([Annual Expense])>= '15000', 'Locations > $15k',
    if(sum([Annual Expense])< '1 5000', 'Locations < $15k'))

[agigliotti]

maybe this:
=aggr( if( sum([Annual Expense])>= 15000, 'Locations > $15k', 'Locations < $15k'), Locations )

[ChiragPradhan]

Hi,

I don't think it is possible. You would be better off creating this field in the data model.

Regards,

Chirag