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: 
segerchr
Contributor III
Contributor III

Set Analysis not equal

Hey,

the option -= does not work in my example. Can anyone help me ?

count({1<Art={'Training'},Urlaub-={'x'}>}SpielerID)/count(Total Distinct SpielerID)

The code for = does work.

count({1<Art={'Training'},Urlaub={'x'}>}SpielerID)/count(Total Distinct SpielerID).

BR. CS

11 Replies
swuehl
MVP
MVP

Well, it depends if you want to use OR or AND logic to combine your conditions:

=count({1<Art={'Training'},KEY =e({<Urlaub={'x'}>+<verletzt = {'x'}>+<krank = {'x'}>}) >} DISTINCT SpielerID)

=count({1<Art={'Training'},KEY =e({<Urlaub={'x'}, verletzt = {'x'}, krank = {'x'}>}) >} DISTINCT SpielerID)

segerchr
Contributor III
Contributor III
Author

Thanks so much. It works fine