topic Pivot Table - Dimensionality Lookup Values in App Development

topic Pivot Table - Dimensionality Lookup Values in App Development https://community.qlik.com/t5/App-Development/Pivot-Table-Dimensionality-Lookup-Values/m-p/1738217#M56810 <P>I have data that looks like this:</P><TABLE width="1131"><TBODY><TR><TD width="87">collect_date_dt</TD><TD width="87">primary_email</TD><TD width="87">l1_manager_email</TD><TD width="87">l2_manager_email</TD><TD width="87">l3_manager_email</TD><TD width="87">l4_manager_email</TD><TD width="87">l5_manager_email</TD><TD width="87">l6_manager_email</TD><TD width="87">l7_manager_email</TD><TD width="87">l8_manager_email</TD><TD width="87">l9_manager_email</TD><TD width="87">developer_count</TD><TD width="87">total_developer_ct</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp1@sample.com" target="_blank" rel="noopener">emp1@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:emp5@sample.com" target="_blank" rel="noopener">emp5@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp2@sample.com" target="_blank" rel="noopener">emp2@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:emp5@sample.com" target="_blank" rel="noopener">emp5@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp3@sample.com" target="_blank" rel="noopener">emp3@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:emp5@sample.com" target="_blank" rel="noopener">emp5@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp4@sample.com" target="_blank" rel="noopener">emp4@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:emp5@sample.com" target="_blank" rel="noopener">emp5@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD>empm1@sample.com</TD><TD> </TD><TD> </TD><TD><A href="mailto:empm@sample.com" target="_blank" rel="noopener">empm@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:empm2@sample.com" target="_blank" rel="noopener">empm2@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:empm@sample.com" target="_blank" rel="noopener">empm@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:empm3@sample.com" target="_blank" rel="noopener">empm3@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:empm@sample.com" target="_blank" rel="noopener">empm@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:empm@sample.com" target="_blank" rel="noopener">empm@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>4</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp5@sample.com" target="_blank" rel="noopener">emp5@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>5</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>10</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>11</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>12</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>13</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>13</TD><TD>13</TD></TR></TBODY></TABLE><P> </P><P>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:</P><UL><LI>I have no aggregation involved in the measure, just a lookup based on the dimensionality. The roll-up values are also pre calculated for </LI><LI>I would like to show values <FONT color="#993366">not</FONT> <FONT color="#000000">on selection, but when I click on the expansion or drill-down(there's no filter selected)</FONT></LI></UL> Sat, 16 Nov 2024 01:36:41 GMT cosmicQlikSense 2024-11-16T01:36:41Z Pivot Table - Dimensionality Lookup Values https://community.qlik.com/t5/App-Development/Pivot-Table-Dimensionality-Lookup-Values/m-p/1738217#M56810 <P>I have data that looks like this:</P><TABLE width="1131"><TBODY><TR><TD width="87">collect_date_dt</TD><TD width="87">primary_email</TD><TD width="87">l1_manager_email</TD><TD width="87">l2_manager_email</TD><TD width="87">l3_manager_email</TD><TD width="87">l4_manager_email</TD><TD width="87">l5_manager_email</TD><TD width="87">l6_manager_email</TD><TD width="87">l7_manager_email</TD><TD width="87">l8_manager_email</TD><TD width="87">l9_manager_email</TD><TD width="87">developer_count</TD><TD width="87">total_developer_ct</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp1@sample.com" target="_blank" rel="noopener">emp1@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:emp5@sample.com" target="_blank" rel="noopener">emp5@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp2@sample.com" target="_blank" rel="noopener">emp2@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:emp5@sample.com" target="_blank" rel="noopener">emp5@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp3@sample.com" target="_blank" rel="noopener">emp3@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:emp5@sample.com" target="_blank" rel="noopener">emp5@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp4@sample.com" target="_blank" rel="noopener">emp4@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:emp5@sample.com" target="_blank" rel="noopener">emp5@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD>empm1@sample.com</TD><TD> </TD><TD> </TD><TD><A href="mailto:empm@sample.com" target="_blank" rel="noopener">empm@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:empm2@sample.com" target="_blank" rel="noopener">empm2@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:empm@sample.com" target="_blank" rel="noopener">empm@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:empm3@sample.com" target="_blank" rel="noopener">empm3@sample.com</A></TD><TD> </TD><TD> </TD><TD><A href="mailto:empm@sample.com" target="_blank" rel="noopener">empm@sample.com</A></TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>0</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:empm@sample.com" target="_blank" rel="noopener">empm@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>4</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp5@sample.com" target="_blank" rel="noopener">emp5@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>5</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp6@sample.com" target="_blank" rel="noopener">emp6@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>10</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp7@sample.com" target="_blank" rel="noopener">emp7@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>11</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp8@sample.com" target="_blank" rel="noopener">emp8@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>12</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp9@sample.com" target="_blank" rel="noopener">emp9@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>13</TD><TD>13</TD></TR><TR><TD>8/6/20</TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD> </TD><TD><A href="mailto:emp10@sample.com" target="_blank" rel="noopener">emp10@sample.com</A></TD><TD>13</TD><TD>13</TD></TR></TBODY></TABLE><P> </P><P>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:</P><UL><LI>I have no aggregation involved in the measure, just a lookup based on the dimensionality. The roll-up values are also pre calculated for </LI><LI>I would like to show values <FONT color="#993366">not</FONT> <FONT color="#000000">on selection, but when I click on the expansion or drill-down(there's no filter selected)</FONT></LI></UL> Sat, 16 Nov 2024 01:36:41 GMT https://community.qlik.com/t5/App-Development/Pivot-Table-Dimensionality-Lookup-Values/m-p/1738217#M56810 cosmicQlikSense 2024-11-16T01:36:41Z