Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Our May 2021 end-to-end product release from Data Integration to Data Analytics is out! READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
BIDev
Creator
Creator

How can I use sum in Filter pane ?

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'))

 

 

2 Replies
agigliotti
Partner
Partner

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

ChiragPradhan
Creator II
Creator II

Hi,

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

Regards,

Chirag