Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
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