Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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
mwoolf
Honored Contributor II

"<>" in SET ANALYSIS

Field -= {2}

4 Replies
mwoolf
Honored Contributor II

"<>" in SET ANALYSIS

Field -= {2}

MVP
MVP

"<>" in SET ANALYSIS

Hi,

You can use this

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

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

Regards,

Jagan.

chauhans85
Esteemed Contributor

Re: "<>" in SET ANALYSIS

sum( fieldname-={value},measure)

this may gives Red lines but will work

or

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

hope this helps

Not applicable

"<>" in SET ANALYSIS

Thanx mwoolf... it's working

Community Browser