Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

"<>" in SET ANALYSIS

Hi Friends

Do anyone of u know how to use "<>" (not equal to) in set analysis???

Please Reply

Thanks

Ankit

1 Solution

Accepted Solutions
m_woolf
Master II
Master II

4 Replies
m_woolf
Master II
Master II

Field -= {2}

jagan
Luminary Alumni
Luminary Alumni

Hi,

You can use this

Sum({<Year -= {2012}>} Sales)

Above expression excludes 2012 from Year field.  You can use <> like this.

Regards,

Jagan.

SunilChauhan
Champion
Champion

sum( fieldname-={value},measure)

this may gives Red lines but will work

or

sum( fieldname={*},measure)-sum( fieldname={value},measure)

hope this helps

Sunil Chauhan
Not applicable
Author

Thanx mwoolf... it's working