topic Re: Set Analysis Not Equal expression in QlikView

Set Analysis Not Equal expression

Anonymous — Thu, 31 Jul 2014 14:41:11 GMT

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

Re: Set Analysis Not Equal expression

joshabbott — Thu, 31 Jul 2014 14:44:06 GMT

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'?

Re: Set Analysis Not Equal expression

DavidFoster1 — Thu, 31 Jul 2014 14:45:35 GMT

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.

Re: Set Analysis Not Equal expression

male_carrasco — Thu, 31 Jul 2014 14:46:36 GMT

Hi!

which is your Dimension?

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

Ale

Re: Set Analysis Not Equal expression

Thu, 31 Jul 2014 14:48:51 GMT

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

Re: Set Analysis Not Equal expression

SunilChauhan — Thu, 31 Jul 2014 15:15:50 GMT

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

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