Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Aspiring_Developer
Specialist
Specialist

aggregation in expression qliksense

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

1 Reply
Digvijay_Singh

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