Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Coming your way, the Qlik Data Revolution Virtual Summit. October 27-29. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

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
Highlighted
Master II
Master II

This may be

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

View solution in original post

Highlighted
Partner
Partner

Hi,

Please use below Expression to get that:

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

Thanks & regards,
Arvind Patil

View solution in original post

4 Replies
Highlighted
Master II
Master II

This may be

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

View solution in original post

Highlighted
Partner
Partner

Hi,

Please use below Expression to get that:

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

Thanks & regards,
Arvind Patil

View solution in original post

Highlighted
Partner
Partner

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

Highlighted
Community Manager
Community Manager

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