Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Set Analysis Set Modifier - Everything Except

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.

4 Replies
MVP
MVP

Re: Set Analysis Set Modifier - Everything Except

Try like:

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

Or,

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

Re: Set Analysis Set Modifier - Everything Except

Also try with

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

Not applicable

Re: Set Analysis Set Modifier - Everything Except

Hi,

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


will select all the values except Status Closed



Regards,

Joshmi

MVP & Luminary
MVP & Luminary

Re: Set Analysis Set Modifier - Everything Except

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.