Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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..