aggregation in expression qliksense

Aspiring_Developer — Tue, 05 Oct 2021 10:33:34 GMT

Hello,

I have below scenario :-

Division | Department | Person | Sum(Hours)

HR | People| Suresh| 56

Finance| Cost | Naresh|37

My requirement is to create a table with below functionality:-

If is select "Division " - it should show the Hours value as 56+37 =93 then 93/ 2=> 46.5

If select 'Department'- it should be same as above

My final visualization should be like:-

Division |Hours

HR| 46.6

When user select on Division , it should drill down to department like below:-

Department| Hours

People| 46.6

When user select Department, it should show people like below:-

Suresh| 46.6

=========================

As of now, i have created drill dimension in qliksense and then used get selected count for selections.

But how to use do the aggregation like '56+37 =93 then 93/ 2=> 46.5' . I should i achieve in expression for each drill down selection?

Can anyone please help ?

Thanks in advance

Re: aggregation in expression qliksense

Digvijay_Singh — Tue, 05 Oct 2021 12:13:21 GMT

Can you share your test app, I am not able to understand how you can show 46.6 against Suresh when the underlying data has value 56, Similar with HR linked to 56..not able to understand the data model..

topic Re: aggregation in expression qliksense in App Development

aggregation in expression qliksense

Re: aggregation in expression qliksense