Set Analysis Set Modifier - Everything Except

[#1]

I've been searching for the correct syntax, but have come to a dead end. I think it should be something simple.

Basically I am trying to use set analysis to use everything except ' value '

Example:

Statuses:

     Approved

     Open

     Closed

This gives the results I want - {$< Status = {'Approved','Open'}>}

I am looking for something like - {$< Status = { * - 'Closed'}>}

So it is basically everything not in status closed. In this example it makes sense to just type it out, but when the values are text and in large distinct quantities it makes set up monotonous. I assume there is a syntax for it and it's simple, but I have not come across it in my research.

If I am not explaining it well enough, please let me know.

[tresesco]

Try like:

{$< Status = { '*'} - {'Closed'}>}

Or,

{$< Status - = {'Closed'}>}                       // note, '-' (negation) before '='

[CELAMBARASAN]

Also try with

{$-<Status={'Closed'}>}

[#4]

Hi,

{1-$<Status={'Closed'}>}

will select all the values except Status Closed

Regards,

Joshmi

[jagan]

Hi,

Try like this

Sum({<Status - = {'Closed'}>} MeasureName)

Note: Replace MeasureName with your actual field name you want to aggregate.

     This expression shows as syntax error in Qlikview, but it works as expected.

Regards,

Jagan.