topic Set analisis in QlikView

Set analisis

Mon, 04 Jun 2012 13:03:59 GMT

Hi Qlikcommunity. I need exclude a field.

I am trying set analisis.

EJ.
I have:

Colors

Red

Blue

Black

I need:

Colors

Red

Black

My expression is:

COUNT

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

But this does not work

Can they help me?

Thank!!!

CELAMBARASAN — Mon, 04 Jun 2012 13:08:14 GMT

Hi,

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

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

Celambarasan

Mon, 04 Jun 2012 13:21:59 GMT

Great, this works.

Thank you very much!.

Ivan.

spsrk_84 — Mon, 04 Jun 2012 13:24:01 GMT

Hi ,

u can also try like this

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

Thanks,

Shiva