Qlik Community

New to Qlik Community

Discussion board for questions on how to use Qlik Community and its features.

Announcements
This forum is for questions and information about how to use the Qlik Community.
Please do not post product related questions here.
Select the correct forum from: Qlik Product Forums
Highlighted
abhijith28
New Contributor III

Finding the sum

Hi,

Please someone help me with this:

Product,Sales

A,50

B,40

B,65

A,35

C,70

 

I need the output in text box as B:105

because the max value of the total sales of that product.

2 Solutions

Accepted Solutions
pradosh_thakur
Honored Contributor II

Re: Finding the sum

This may be

=only({<Product={"=Sum(Sales)=Max(total AGGR(sum(Sales),Product))"}>}Product ) & ':' & Max(AGGR(sum(Sales),Product))
Learning never stops.
arvind_patil
Valued Contributor III

Re: Finding the sum

Hi,

Please use below Expression to get that:

FirstSortedValue(ID,-aggr(sum(Value),ID))&':'&MAx(Aggr(Sum(Value),ID))

Thanks & regards,
Arvind Patil
4 Replies
pradosh_thakur
Honored Contributor II

Re: Finding the sum

This may be

=only({<Product={"=Sum(Sales)=Max(total AGGR(sum(Sales),Product))"}>}Product ) & ':' & Max(AGGR(sum(Sales),Product))
Learning never stops.
arvind_patil
Valued Contributor III

Re: Finding the sum

Hi,

Please use below Expression to get that:

FirstSortedValue(ID,-aggr(sum(Value),ID))&':'&MAx(Aggr(Sum(Value),ID))

Thanks & regards,
Arvind Patil
arvind_patil
Valued Contributor III

Re: Finding the sum

Please find the attached table.

Data:
Load * inline [
ID,Value
A,50

B,40

B,65

A,35

C,70 ];
Exit Script;

Thanks & Regards,

Arvind Patil

Community Manager
Community Manager

Re: Finding the sum

Is this for QlikView or Sense as I would like to move into the correct product forum
Sue Macaluso
Community Browser