If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
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'))
maybe this:=aggr( if( sum([Annual Expense])>= 15000, 'Locations > $15k', 'Locations < $15k'), Locations )
I don't think it is possible. You would be better off creating this field in the data model.