condicional <> o >

[mauroosorio]

tengo problemas con esta expresion

sum (count({<estado_empleado = {'Activo', codigo_empresa <> {'1'} >} ),'#.##0')

como puedo manejar el condicional <> sin que me genere error

error in set modifier ad hoc element list

[Oleg_Troyansky]

1. It looks like you are missing a closing bracket after 'Activo'.

2. Also, numeric values can't be compared like this. Instead, move the comparison into the search:

3. What's the field that you are counting ?

4. The formatting string belongs to the function num, but there is no num() here?

5. You can't use SUM() and COUNT() together without using AGGR() between them.

Here is what's left:

count({<estado_empleado = {'Activo'}, codigo_empresa = {"<>1"} >} MISSING_FIELD)

cheers,

Oleg Troyansky

www.masterssummit.com - take your QlikView skills to the next level!

[anbu1984]

count({<estado_empleado = {'Activo'}, codigo_empresa -= {"1"} >} MISSING_FIELD)

[mauroosorio]

muchas gracias ,  esa era la solucion que necesitaba

[anbu1984]

If your queries are answered, please close the post by selecting correct answer.