Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
pgalvezt2021
Partner - Contributor III
Partner - Contributor III

Extract a row and sum the rest of rows

Hello,

How can I extract 558520 ? What I want is sum all except 558520,

Can you help me with this please?

Thanks !

pgalvezt2021_0-1669042929153.png

Labels (1)
1 Solution

Accepted Solutions
pgalvezt2021
Partner - Contributor III
Partner - Contributor III
Author

Got it !

 

(Sum(Aggr(
Sum(Venta) -
If(Len(GetFieldSelections(Filter)), Sum({<Cliente={"=Filter=Cliente"}>}DISTINCT Venta)),Cliente,Filter)))
/
(Count(Cliente)-
If(Len(GetSelectedCount(Filter)), Count({<Cliente={"=Filter=Cliente"}>}DISTINCT Cliente)))

View solution in original post

1 Reply
pgalvezt2021
Partner - Contributor III
Partner - Contributor III
Author

Got it !

 

(Sum(Aggr(
Sum(Venta) -
If(Len(GetFieldSelections(Filter)), Sum({<Cliente={"=Filter=Cliente"}>}DISTINCT Venta)),Cliente,Filter)))
/
(Count(Cliente)-
If(Len(GetSelectedCount(Filter)), Count({<Cliente={"=Filter=Cliente"}>}DISTINCT Cliente)))