topic Aggregation in Qlik sense in App Development

Aggregation in Qlik sense

saurav5246 — Fri, 15 Nov 2024 20:56:21 GMT

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))

Re: Aggregation in Qlik sense

TauseefKhan — Thu, 20 Jun 2024 06:31:35 GMT

Hi @saurav5246,

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.***

Re: Aggregation in Qlik sense

saurav5246 — Thu, 20 Jun 2024 13:20:28 GMT

Thanks for the solution.👍

Re: Aggregation in Qlik sense

kaska — Thu, 11 Jul 2024 10:47:09 GMT

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

Re: Aggregation in Qlik sense

Dana_Baldwin — Thu, 11 Jul 2024 15:36:14 GMT

Hi @saurav5246

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