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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
Vittore_8
Contributor
Contributor

Operator except, exclude from the set?

Hi, please help me! 

How can I get next rezult?

{A} - {B} = {D}

Vittore_8_0-1620155134375.png

 

Labels (2)
1 Reply
Dalton_Ruer
Support
Support

1. I have attached a QVF with working example

2. Set Analysis formula can be done between 2 alternate states like this: 

Concat( { <Field=P({'State 1'})> - <Field=P({'State 2'})>} Field, ', ')

3. Here is a post with a complete hands on Set Analysis workshop if you want to go deeper. 

4. Go to Master Items to create/see the Alternate States

Dalton_Ruer_0-1620158725981.png