Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On-Demand Webinar: Learn proven best practices for a smooth transition to Qlik Sense® SaaS. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
zagzebski
Creator
Creator

Searching with Set Analysis

I want to have a text box or button where I could search on the following:

Sum( {<[Line of Business]={'Employee Benefits'}>} [Amount Revenue])  > 0

The user clicks on the button and the chart filters on customers that have a line of business of employee benefits with Revenue greater than 0

Any ideas on how to do this?

Zag

1 Solution

Accepted Solutions
swuehl
MVP
MVP

Try a Selection - Select in field button action with field

Customer

(or the field name for your customers) and search string

='=Sum( {<[Line of Business]={"Employee Benefits"}>} [Amount Revenue])  > 0'

View solution in original post

4 Replies
swuehl
MVP
MVP

Try a Selection - Select in field button action with field

Customer

(or the field name for your customers) and search string

='=Sum( {<[Line of Business]={"Employee Benefits"}>} [Amount Revenue])  > 0'

jonas_rezende
Specialist
Specialist

Hi, zagzebski.

See the example attached help.

I used a variable to receive the expression according to the click on the button. The table is filtered depending  on action.

P.S.: if it works, adapt to their expression.

I hope this helps!

zagzebski
Creator
Creator
Author

Thanks!

zagzebski
Creator
Creator
Author

Thanks so much!