Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Now Live: Qlik Sense SaaS Simplified Authoring – Analytics Creation for Everyone: READ DETAILS
cancel
Showing results for 
Search instead for 
Did you mean: 
schuffe
Contributor III
Contributor III

Determine the number of groups without profit

Hello

I prepared some Data to explain my problem:

Unbenannt.PNG

My Goal is to make a KPI, that tells me how many groups didnt made profit (consider each day individually) and I want to analyse a period of time (e.g. 01.01.2020 - 31.01.2020).

In my Example the KPI would tell me 4 (B,E on 01.01.2020 and B,D on 02.01.2020).  

Thanks in advance.

1 Solution

Accepted Solutions
lironbaram
Partner - Master III
Partner - Master III

HI 
sum(aggr(if(sum(Profit)>0,0,1),Group,Date))
should give you the results you want

View solution in original post

2 Replies
lironbaram
Partner - Master III
Partner - Master III

HI 
sum(aggr(if(sum(Profit)>0,0,1),Group,Date))
should give you the results you want

schuffe
Contributor III
Contributor III
Author

Thank You, thats perfect 👍