This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion board where members can learn more about Qlik Sense App Development and Usage.
I prepared some Data to explain my problem:
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.
HI sum(aggr(if(sum(Profit)>0,0,1),Group,Date))should give you the results you want
View solution in original post
Thank You, thats perfect 👍