Skip to main content

New to Qlik Sense

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

Announcements
NEW webinar Dec. 7th: 2023 Outlook, A Pivotal Year for Data Integration SIGN ME UP!
cancel
Showing results for 
Search instead for 
Did you mean: 
BI_Dev
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'))

 

 

Labels (4)
2 Replies
agigliotti
Partner - Master III
Partner - Master III

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