Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Posting on Qlik Community is temporarily paused for some users. Thank you for patience and we'll update you soon!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

I need help with set analysis

I have this Count({1<ZONA+={'ZONA XXXX'}>} process_id) set analysis but I need to add another conditions like ZONA XXXX AND CANT > 2 .

I need suggestions.

Labels (1)
5 Replies
Clever_Anjos
Support
Support

Count({1<ZONA+={'ZONA XXXX'}, CANT={">2"}>} process_id)

Not applicable
Author

Thanks for your help but I have another problem. I have a lot of zone but I want eliminate cant > 2 when only the zone is XXXX, that set analysis filter all zone with cant >2. 

Not applicable
Author

Thanks for your help but I have another problem. I have a lot of zone but I want eliminate cant > 2 when only the zone is XXXX, that set analysis filter all zone with cant >2.

Clever_Anjos
Support
Support

If you eliminate cant > 2

Count({1<ZONA+={'ZONA XXXX'}, CANT={"<=2"}>} process_id)

jonathandienst
Partner - Champion III
Partner - Champion III

Is this what you need:

     Count({<ZONA={'XXXX'}> + <CANT={">2"}>} process_id)

Either ZONA = 'XXXX' or CANT > 2

HTH

Jonathan

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein