Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
Not applicable

Set analysis, how to exclude data

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

Tags (1)
1 Solution

Accepted Solutions
Highlighted

Re: Set analysis, how to exclude data

try,

you missed one '}'

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

View solution in original post

28 Replies
Highlighted
Esteemed Contributor III

Re: Set analysis, how to exclude data

can u post the sample qvw?

Highlighted
Not applicable

Re: Set analysis, how to exclude data

Hi Jean-Philippe,

The correct syntax for the exlusion is:

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

Greetz,

Marc Algera

Highlighted
Honored Contributor III

Re: Set analysis, how to exclude data

try like this

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

Highlighted

Re: Set analysis, how to exclude data

try,

you missed one '}'

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

View solution in original post

Highlighted
Not applicable

Re: Set analysis, how to exclude data

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

Joe

Highlighted
Not applicable

Re: Set analysis, how to exclude data

thanks solved,

Highlighted
Not applicable

Re: Set analysis, how to exclude data

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

Highlighted
Not applicable

Re: Set analysis, how to exclude data

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

{'Miscellaneous','Others'}


Joe

Highlighted
Not applicable

Re: Set analysis, how to exclude data

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