Discussion board where members can get started with Qlik Sense.
I need to calculate Revenue at negative EBITDA corresponding to customers and leaders.
And we have 100s of customer under one leader.
The expression I used as below:
if((aggr(sum(EBIDTA),leaders,[Customer Group Descr]))<0,sum(Revenue))
The values corresponding to individual customers are correct but Total is not correct.
Please help me.
can you post your qvf and expected output.
I think you are missing something at the time of group by in expression.
thanks it get done