Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

divyanshi
New Contributor II

condition for revenue at negative EBITDA

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:

1.

if((aggr(sum(EBIDTA),leaders,[Customer Group Descr]))<0,sum(Revenue))

2.

Sum({$<EBIDTA={'<0'}>}Revenue).

The values corresponding to individual customers are correct but Total is not correct.

Please help me.

3 Replies
arulsettu
Honored Contributor III

Re: condition for revenue at negative EBITDA

can you post your qvf and expected output.

arvind_patil
Valued Contributor III

Re: condition for revenue at negative EBITDA

Hi Divyanshi,

I think you are missing something at the time of group by in expression.

Thanks,

Arvind Patil

divyanshi
New Contributor II

Re: condition for revenue at negative EBITDA

thanks it get done

Community Browser