Set Analysis and Aggregation

[Manish_Kumar_]

Hi QlikCommunity,

I have below set of sample data, where I require a Sum of Amount on maximum Weightage 

InputDATA:

LOAD * INLINE [
Sno, Weightage, Amount
100, 2, 10
101, 2, 20
101, 3, 30
101, 4, 40
104, 5, 50
100, 2, 20
105,6,60
];

And the expected output should be like the below:

Sno, Weightage, Amount
100, 2, 30
101, 4, 40
104, 5, 50
105,6,60

I want this using Set analysis or if the condition can also be there but would prefer set as I have huge dataset..

Also I want this in Frontend only,cannot manipulate data in backend as it will increase the reload time of the application

[sidhiq91 · Accepted solution]

@Manish_Kumar_ Please see below the screen shot that shows you even the expression that I have used. 

Let me know if this has resolved your issue.

If it resolved your issue, please like and accept it as a solution.

[Manish_Kumar_]

Hi @sidhiq91 

Your expression worked perfect,

Would be better, if you could explain this a little, for clarification of concepts!!

[sidhiq91]

@Manish_Kumar_ 

Firstly I used Max(Weightage) to find the Max_Weightage value

Secondly, Aggregation is used to group the Amount based on Weightage and Sno and then I took the Max value of that.

[Manish_Kumar_]

@sidhiq91 Perfect!! got it... Thanks