Count based on multiple conditions

[Sree_1]

Hi Everyone,

My problem statement is like, Now my data set consists of columns like 'Task' and 'Task Life cycle' and the life cycle column consists various values like 1-planning, 2-designing, 3-development, 4-deployment, 5-maintenance, 6-decomission. So, now I have display a KPI that displays tasks from 1-planning to 4-deployment as active tasks and 5-maintenance and 6-decomission inactive tasks. Can anyone give the set analysis expressions to display the data in KPIs.

Thanks in advance!!

[BrunPierre · Accepted solution]

Num(Count({<[Task Life cycle]={'planning','designing','development','deployment'}>}DISTINCT Tasks)'###########,###') //active tasks

Num(Count({<[Task Life cycle]={'maintenance','decomission'}>}DISTINCT Tasks)'###########,###') //inactive tasks

?

For more information regarding set analysis, please refer here: Set analysis 

[vinieme12]

Refer this blog to learn more about set analysis

https://www.analyticsvidhya.com/blog/2014/01/set-analysis-qlikview/