Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Highlighted
daniel_sanchezm
Contributor

Conditional Sum

Hello Good evening,

I would like to add the value of a field when the condition is valid, I'm using the following formula:

=IF(Sum(Aggr(Sum(Venta),Marca))>Sum(Aggr(Sum({<Tipo={[Medios]}>} Inversion),Marca)),Num(Sum(Aggr(Sum(Venta),Marca)),'$#,##0'))

But that expression gives me the total value of the sell and I would like to see onlye the value of the sell in those cases where the investment in media is grater. And that why I'm using the AGGT at a brand level

Does somebody can help me? Im using the formula in a text object

Thank you

1 Solution

Accepted Solutions
MVP
MVP

Re: Conditional Sum

=Num(SUM(Aggr(IF(SUM(Venta)>SUM({<Tipo = {'Medios'}>}Inversion),SUM(Venta),Marca)),'$#,##0')

2 Replies
MVP
MVP

Re: Conditional Sum

=Num(SUM(Aggr(IF(SUM(Venta)>SUM({<Tipo = {'Medios'}>}Inversion),SUM(Venta),Marca)),'$#,##0')

daniel_sanchezm
Contributor

Re: Conditional Sum

Thank you!!! It Works