topic Re: Dynamic Aggregation in QlikView

Dynamic Aggregation

boopeshj — Sat, 16 Nov 2024 02:38:33 GMT

Hey Experts,

There are 4 fields. Need aggregation to show data as in the next table.

F1	F2	F3	F4
F1-1	F2-Value	F3-Value	Country1
F1-1	F2-Value	F3-Value	Country2
F1-1	F2-Value	F3-Value	Country3
F1-1	F2-Value	F3-Value1	Country1
F1-1	F2-Value	F3-Value2	Country1
F1-1	F2-Value	F3-Value3	Country1

Want a straight table :

Required Expression

F1-1

F2-Value

Country1; Country2; Country3;

F3-Value

Country1;

F3-Value1

Country1;

F3-Value2

Country1;

F3-Value3

I know it is possible to do it in the Load Script. But I want it to be dynamic. So if a user selects country1 then they should get only those projects.

Re: Dynamic Aggregation

sunny_talwar — Mon, 26 Aug 2019 11:57:55 GMT

Something like this?

With selection

Re: Dynamic Aggregation

boopeshj — Thu, 29 Aug 2019 12:53:02 GMT

Thanks Sunny for the response.

One small problem is that the result set should be one row instead of 4. 😞

Thats the key challenge. 🙂

Re: Dynamic Aggregation

sunny_talwar — Thu, 29 Aug 2019 13:14:30 GMT

Here is one row... bu the height of the cell won't adjust automatically

Re: Dynamic Aggregation

Brett_Bleess — Wed, 04 Sep 2019 21:53:21 GMT

Boopesh, did Sunny's final suggestion work? If so, please be sure to give him credit for the help by marking one or both of his posts by clicking on the Accept as Solution button, so others will know as well.

Regards,
Brett