Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT
mov
Esteemed Contributor III

Re: Using the 1 in set analysis but allowing certain selections

This should work:

SUM({1<RedFlag={1}, Region=P(Region)>} Sales)

Regards,

Michael


View solution in original post

MVP
MVP

Re: Using the 1 in set analysis but allowing certain selections

I can't see what you're saying, but i have lots of fields.

You can let QV do the work to create a list of all fields to clear, have a look into:

Ignore all selections except some specific fields using Set Analysis

Highlighted
evason75
Contributor

Re: Using the 1 in set analysis but allowing certain selections

Thanks Michael.

I was actually using your other suggestion that you made on another post which involved using a variable and GetFieldSelections

Cheers

mov
Esteemed Contributor III

Re: Using the 1 in set analysis but allowing certain selections

Understood..
My suggestion above makes sense only if you actually select a Region.  Later I thought that it is better to use a variable.  Didn't rememebr I'd answered a similar question before... 🙂