Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
Highlighted
aamertaimor
New Contributor III

Set Analysis Not Equal expression

hi,

I am trying to exclude all values where Status is equal to Cancelled.

I tried both of these but couldn't exclude.

=count({$<[Contract Duration]={'no end date'}, [Status]={'*'}-{'Cancelled'}>}DISTINCT [Contract No])

=count({$<[Contract Duration]={'no end date'}, [Status]-={'Cancelled'}>}DISTINCT [Contract No])

Regards,

aamertaimor

Tags (4)
5 Replies
joshabbott
Contributor III

Re: Set Analysis Not Equal expression

Both of those look correct to me.  Any chance you can upload a sample?  Is it possible the Status is actually spelled with only 1 'l'?

dfoster9
Valued Contributor

Re: Set Analysis Not Equal expression

The second should work nicely. I would suggest that there is a mismatch between your data and the set analysis. The 'contract duration' field would suggest a number not a string. Double-check capitalisation as well.

male_carrasco
Contributor

Re: Set Analysis Not Equal expression

Hi!

which is your Dimension?

If you dimension is Status, edit Dimension and try If(Status<>Cancelled,Status)

Ale

Not applicable

Re: Set Analysis Not Equal expression

Just out of curiosity did If () work, like

Count(If([Contract Duration]='no end date' and Status<> 'Cancelled'), Distinct [Contract No])

Also if you could attach a sample file it will be much easier to debug.

Thanks

SunilChauhan
Esteemed Contributor

Re: Set Analysis Not Equal expression

copy  value from Status as Cancelled  and paste to above expressions.might be there is some space in Status column

or

take two list box one for

[Contract Duration]  and select  no end date and then see in [Status] weither there is Cancelled in white or grayed out


if it is grayed out means there is no combination of  noend date and Cancelled.



and hence no result


hope this helps