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

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cosmicQlikSense
Contributor
Contributor
‎2020-08-24 12:13 PM

Pivot Table - Dimensionality Lookup Values

I have data that looks like this:

collect_date_dtprimary_emaill1_manager_emaill2_manager_emaill3_manager_emaill4_manager_emaill5_manager_emaill6_manager_emaill7_manager_emaill8_manager_emaill9_manager_emaildeveloper_counttotal_developer_ct
8/6/20emp1@sample.com  emp5@sample.comemp6@sample.comemp7@sample.comemp8@sample.comemp9@sample.comemp10@sample.com013
8/6/20emp2@sample.com  emp5@sample.comemp6@sample.comemp7@sample.comemp8@sample.comemp9@sample.comemp10@sample.com013
8/6/20emp3@sample.com  emp5@sample.comemp6@sample.comemp7@sample.comemp8@sample.comemp9@sample.comemp10@sample.com013
8/6/20emp4@sample.com  emp5@sample.comemp6@sample.comemp7@sample.comemp8@sample.comemp9@sample.comemp10@sample.com013
8/6/20empm1@sample.com  empm@sample.comemp6@sample.comemp7@sample.comemp8@sample.comemp9@sample.comemp10@sample.com013
8/6/20empm2@sample.com  empm@sample.comemp6@sample.comemp7@sample.comemp8@sample.comemp9@sample.comemp10@sample.com013
8/6/20empm3@sample.com  empm@sample.comemp6@sample.comemp7@sample.comemp8@sample.comemp9@sample.comemp10@sample.com013
8/6/20empm@sample.com   emp6@sample.comemp7@sample.comemp8@sample.comemp9@sample.comemp10@sample.com413
8/6/20emp5@sample.com   emp6@sample.comemp7@sample.comemp8@sample.comemp9@sample.comemp10@sample.com513
8/6/20emp6@sample.com    emp7@sample.comemp8@sample.comemp9@sample.comemp10@sample.com1013
8/6/20emp7@sample.com     emp8@sample.comemp9@sample.comemp10@sample.com1113
8/6/20emp8@sample.com      emp9@sample.comemp10@sample.com1213
8/6/20emp9@sample.com       emp10@sample.com1313
8/6/20emp10@sample.com       emp10@sample.com1313

 

I want to create a drilldown pivot chart that shows developer count for each employee for a particular date (check attachment for sample app). The problems I'm facing are:

  • I have no aggregation involved in the measure, just a lookup based on the dimensionality. The roll-up values are also pre calculated for 
  • I would like to show values not on selection, but when I click on the expansion or drill-down(there's no filter selected)
Labels (3)
Preview file
13 KB
community.qvf
676 Views
0 Likes
0 Replies