Aggregation in Qlik sense

[saurav12345678]

Hi All,

I want have one table with these details:

Name, Position, JV
Sujoy, Chairman, TOTAL Private Limited
Sujoy, Director, MontneyLimited
Sujoy, Chairman, PlcSrilanka
Sujoy, Director, Shareholder in PetroCarabobo

i want output like this in straight table in single row:

NM	Details
Sujoy	Chairman:TOTAL Private Limited,Plc, Srilanka Director: Montney Limited,Shareholder in PetroCarabobo

I am using following expression but not getting output:

Concat(distinct [Joint Venture Position] & JV_NAME,chr(10))

[TauseefKhan · Accepted solution]

Hi @saurav12345678,

tDetails:
Load * Inline [
Name, Position, JV
Sujoy, Chairman, TOTAL Private Limited
Sujoy, Director, MontneyLimited
Sujoy, Chairman, PlcSrilanka
Sujoy, Director, Shareholder in PetroCarabobo
];

ConcatenatedDetails:
Load
Name,
Position & ':' & Concat(JV, ', ') as Details
Resident tDetails
Group By Name, Position;

Load
Name as NM,
Concat(Details, Chr(10)) as Details 
Resident ConcatenatedDetails
Group By Name;

Drop Table ConcatenatedDetails;

***Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.***

[saurav12345678]

Thanks for the solution.👍

[kaska]

In Qlik it seems like you could just sum the lowest level data and it would aggregate up to the higher level dimensions. For really specific calculations on different pivot columns or rows you can use pick(match()) expressions over the pivot table dimensions to slot in different expressions for different parts of the table

[Dana_Baldwin]

Hi @saurav12345678 

Just for future reference, the forum you posted to is for product Qlik Enterprise Manager, a data integration product. To reach the right audience for Qlik Sense, please post items here:

Qlik Sense | Qlik Community

Thanks!

Dana