Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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 (5)
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