Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@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_ 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.
Hi @sidhiq91
Your expression worked perfect,
Would be better, if you could explain this a little, for clarification of concepts!!
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.
@sidhiq91 Perfect!! got it... Thanks