Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik!
I am trying to create an AGGR Summary table of the total representatives located by region by their department where they represent greater than or equal to 50% of the entire organization department.
For Example EU has 30 reps for distribution out of 37 total for the 'Deptlvl4' column.
Deptlvl2 | Deptlvl4 | Region | Reps | Grand Total | T/F |
Build | Distribution | AP | 2 | 37 | False |
Build | Distribution | EU | 30 | 37 | True |
Build | Distribution | NA | 5 | 37 | False |
However I am unable to get Qlik to display/process the data correctly. It will display 'Nulls' for 2 of the 3 rows.
Qlikview Table (see attached for example)
Deptlvl2 | Deptlvl4 | Region | Reps | Grant Total | T/F |
Build | Distribution | AP | 2 | 37 | FALSE |
Build | Distribution | EU | 30 | - | FALSE |
Build | Distribution | NA | 5 | - | FALSE |
add a nodistinct to the aggr:
Aggr(nodistinct Sum({1<
Deptlvl4 = {"*"}
>}
[Total Reps])
,
Deptlvl4)
add a nodistinct to the aggr:
Aggr(nodistinct Sum({1<
Deptlvl4 = {"*"}
>}
[Total Reps])
,
Deptlvl4)
Thank you Edwin!