group by records in application not in script - Qlik Community

Report Inappropriate Content · ‎2016-09-15

Hi,

I have below sample records coming from SQL , I want to group those records and show sum of amount in report

Is there any function I can use to achieve at application or report level , I do not want to apply any change at script level

I

Expected Results:

Message was edited by: Vibhu Sharma

sunny_talwar · ‎2016-09-15

May be create a straight table

Dimensions

Header 1

Header 2

Expression

Sum([Header 3])

Report Inappropriate Content · ‎2016-09-15

will it include group by automatically for Item and Region

Anonymous · ‎2016-09-15

Yes It will apply grouping for both Item and then Region

swuehl · ‎2016-09-15

You are touching the very core of QlikView (and similar tools in general), understanding

sunny_talwar · ‎2016-09-15

I don't see a reason why it won't