Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
cancel
Showing results for 
Search instead for 
Did you mean: 
damian_spyra
Contributor III
Contributor III

dynamic boolean function (set analysis)

Hi there,

i'm engaged with an idea. I want to dimically compose (set analysis) function.

I have medical methods and associated results. What i'm trying to do is, dynamically compose a selection over some methods and certain results wirh boolean conjunction.

Let's say, i want to analyse all data related to following selection:

= (method01 with resultA) and (method02 with resultB) or (method03 with resultA) and ...

I thought, i can do this with set analysis. So i defined new field BOOLEAN with Expression "AND", "OR" and try to select $, $1, $2 over fields of methods, results and boolean. But now i stuck...

How wolud you implement such a requirement?

Thanks for any idea!

1 Reply
Not applicable

sure

this is what you do:

sum({$<(method01 = {"resultA"} > * ( <method02= {"resultB"}> + <method03= {"resultA"}>)}  Sales)

Benji