topic Re: Searching with Set Analysis in QlikView

Searching with Set Analysis

zagzebski — Mon, 02 May 2016 21:35:25 GMT

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

swuehl — Mon, 02 May 2016 21:44:37 GMT

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 — Tue, 03 May 2016 12:45:45 GMT

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 — Tue, 03 May 2016 20:51:50 GMT

Thanks!

zagzebski — Tue, 03 May 2016 20:52:04 GMT

Thanks so much!