Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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.

5 Replies
Employee
Employee

Re: I need help with set analysis

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

Not applicable

Re: I need help with set analysis

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

Re: I need help with set analysis

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.

Employee
Employee

Re: I need help with set analysis

If you eliminate cant > 2

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

MVP
MVP

Re: I need help with set analysis

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
Community Browser