19. Aggr Function & Range Sum function in Qlik Sense

Aggr Function:
It Groups the data Based on the Group you are entering
It is used to aggregate two or Aggregation function.
Range Sum: Range sum function is used to sum up all the values in a column where we have a mixture of character and number values. It ideally sum up all the number values and leave off the character values
Link: For the Document: drive.google.c...
Note: (Document is for briefs, not for the detail description)
For more videos please visit: • 1. Introduction to Qli...
Please follow me on:
LinkedIn: linkedin.com/in/biswadeep-moitra-98137079
Gmail: [e-mail]
Facebook: / biswadeep.moitra
Instagram: / biswadeep_moitra

[@PochinkiVeteran]

Great explanation ❤

[@krrishnasingh2008]

Very well explained aggr function.

[@tabrezmohammed]

thank you. very helpful .

[@gczz]

In my mind, SUM(AGGR(MAX(Salary),City)) is showing the same as MAX(Salary) if you have a City as dimension (as is your case).

[@qlik2expressbiswadeepmoitr305]

True, one result can be achieved by multiple ways

[@trekkercortuga]

wouldnt simple max(salary) been enough, instead of aggr func?

[@qlik2expressbiswadeepmoitr305]

Aggr is used depending upon the requirement. For example: you have a table where you show max of salary and the dimension is 'name', so the salary is automatically getting grouped by 'name'. Now, if requirement is you need to find max salary by department but you can't have a dimension (only 'name' should be dimension). Then you need to use aggr to specifically group it by department

[@dheerendrakumarsharma7086]

How can I connect with you sir

[@qlik2expressbiswadeepmoitr305]

Hi please email me on [e-mail], will share you my contact details there