Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

New 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

Re: dynamic boolean function (set analysis)


this is what you do:

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