Set analysis, how to exclude data

[#1]

Hello

I am working on a graph to show different actions, but i want to EXCLUDE the ones with the types called "Miscellaneous".

i have been this expression but i have an error message like Error in set modifier Ad hoc element list....any clue ????

=Count({<types=-{'Miscellaneous'>} distinct manif.K_ACTION)

thanks

JP

[Chanty4u]

can u post the sample qvw?

[#3]

Hi Jean-Philippe,

The correct syntax for the exlusion is:

=Count({<types -= {'Miscellaneous'} >} distinct manif.K_ACTION)

Greetz,

Marc Algera

[arulsettu]

try like this

=Count({<types=-{'Miscellaneous'}>} distinct manif.K_ACTION)

[Kushal_Chawda · Accepted solution]

try,

you missed one '}'

Count({<types=-{'Miscellaneous'}>} distinct manif.K_ACTION)

[#6]

just an FYI, maybe also worth saying this syntax will still highlight as incorrect but it is actually correct

Joe

[#7]

thanks solved,

[#8]

if you would like to exclude another types, you can add afterwards ? i need to exclude also "Others"

[#9]

You can include yes, just add it as an extra entry in the set,

{'Miscellaneous','Others'}

Joe

[#10]

mais oui of course...i think that i need a coffee