topic Set Analysis Operator in QlikView

Set Analysis Operator

marco_puccetti — Thu, 18 Jun 2015 13:21:14 GMT

Hello i need an operator used to count element not ugual to a certain condition like this it doesn't work:

=Count({<STATO<>{'SCADUTA'},STATO<>{'ATTIVATA'}> }DISTINCT NUMERO_PROPOSTA)

How can be made without using the <> operator?

Thanks

Marco

giakoum — Thu, 18 Jun 2015 13:22:32 GMT

replace <> with -=

giakoum — Thu, 18 Jun 2015 13:23:04 GMT

=Count({<STATO-={'SCADUTA','ATTIVATA'}> }DISTINCT NUMERO_PROPOSTA)

sunny_talwar — Thu, 18 Jun 2015 13:25:27 GMT

or this should also work for you

=Count({<STATO = e({<STATO = {'SCADUTA','ATTIVATA'}>})>} DISTINCT NUMERO_PROPOSTA)

johngouws — Thu, 18 Jun 2015 13:27:16 GMT

Hi there Marco,

try:

=Count({<STATO += {'SCADUTA'},STATO += {'ATTIVATA'}> }DISTINCT NUMERO_PROPOSTA)

You will get a red underline but it is ok.

giakoum — Thu, 18 Jun 2015 13:28:36 GMT

Marco is asking for not equal

johngouws — Thu, 18 Jun 2015 13:33:38 GMT

Hi Marco,

Sorry it is -= NOT +=

marco_puccetti — Thu, 18 Jun 2015 13:50:43 GMT

Thanks

Marco