Set analisis

[#1]

Hi Qlikcommunity. I need exclude a field.

I am trying set analisis.

EJ.
I have:

Colors

Red

Red

Red

Red

Blue

Blue

Blue

Black

Black

I need:

Colors

Red

Red

Red

Red

Black

Black

My expression is: 

COUNT

(~Colors = {'Blue'} >}Cant)

But this does not work

Can they help me?

Thank!!!

[CELAMBARASAN · Accepted solution]

Hi,

     Check with -= Which is used for excluding the give values.

     Count({<Colors-={'Blue'}>} Colors)

Celambarasan

[#3]

Great, this works.

Thank you very much!.

Ivan.

[spsrk_84]

Hi ,

u can also try like this

Count({<Colors=Colors-{'Blue'}>}Colors)

Thanks,

Shiva