topic Set Analysis Set Modifier - Everything Except in QlikView

Set Analysis Set Modifier - Everything Except

Tue, 21 Oct 2014 04:19:56 GMT

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.

Re: Set Analysis Set Modifier - Everything Except

tresB — Tue, 21 Oct 2014 04:34:42 GMT

Try like:

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

Or,

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

Re: Set Analysis Set Modifier - Everything Except

CELAMBARASAN — Tue, 21 Oct 2014 04:36:57 GMT

Also try with

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

Re: Set Analysis Set Modifier - Everything Except

Tue, 21 Oct 2014 05:10:34 GMT

Hi,

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

will select all the values except Status Closed

Regards,

Joshmi

Re: Set Analysis Set Modifier - Everything Except

jagan — Tue, 21 Oct 2014 06:07:55 GMT

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.