topic Show hierarchy items count without aggregation in diagrams in App Development https://community.qlik.com/t5/App-Development/Show-hierarchy-items-count-without-aggregation-in-diagrams/m-p/1334294#M29192 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>i have a typical product hierarchy with a count field for each product.</P><P></P><P>As a sample:</P><P></P><P>ProductID, Productname, Parent, Count</P><P></P><P>1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Product1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Product2,&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Product3,&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>......</P><P></P><P>To import the data i use the Hierarchy statement with corresponding parameters.</P><P></P><P>I want to show in my diagrams the count value of the underlying products </P><P>and not aggregated values over the entire hierarchy.</P><P></P><P>What is the right measure definition for that? </P></BODY></HTML> Wed, 19 Jul 2017 09:36:38 GMT 2017-07-19T09:36:38Z Show hierarchy items count without aggregation in diagrams https://community.qlik.com/t5/App-Development/Show-hierarchy-items-count-without-aggregation-in-diagrams/m-p/1334294#M29192 <HTML><HEAD></HEAD><BODY><P>Dear all,</P><P></P><P>i have a typical product hierarchy with a count field for each product.</P><P></P><P>As a sample:</P><P></P><P>ProductID, Productname, Parent, Count</P><P></P><P>1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Product1,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 10</P><P>2,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Product2,&nbsp;&nbsp;&nbsp;&nbsp; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20</P><P>3,&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Product3,&nbsp;&nbsp;&nbsp;&nbsp; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 5</P><P>......</P><P></P><P>To import the data i use the Hierarchy statement with corresponding parameters.</P><P></P><P>I want to show in my diagrams the count value of the underlying products </P><P>and not aggregated values over the entire hierarchy.</P><P></P><P>What is the right measure definition for that? </P></BODY></HTML> Wed, 19 Jul 2017 09:36:38 GMT https://community.qlik.com/t5/App-Development/Show-hierarchy-items-count-without-aggregation-in-diagrams/m-p/1334294#M29192 2017-07-19T09:36:38Z