Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
warrentk80
Creator
Creator

field selection exclusion from setanalisys

Hello, an expression how can I not consider selecting a particular filter? I guess you have to use the set analysis but what is the syntax? with the characters   1 I consider or not the filters but if I wanted to exclude only the selection of a filter (field called FLAG) how should I do?

 

Thank you

2 Replies
tresesco
MVP
MVP

Sum( {<FLAG , AnotherField>} Sales) --- ignores only two fields selections

Brett_Bleess
Former Employee
Former Employee

Andrea, try the following links for further help, and if the other post was what you needed, please be sure to give them credit by using the Accept as Solution button...

https://help.qlik.com/en-US/qlikview/April2019/Subsystems/Client/Content/QV_QlikView/ChartFunctions/...

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

The latter is likely the one that will be the best place to start...

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.