topic How to get the next level data for a hierarchical dimension? in Integration, Extension & APIs https://community.qlik.com/t5/Integration-Extension-APIs/How-to-get-the-next-level-data-for-a-hierarchical-dimension/m-p/1425607#M8887 <HTML><HEAD></HEAD><BODY><P>I am writing a stacked group d3 extension which accepts a hierarchical dimension (Country&gt; brand&gt; mixture) and year dimension and three measures (spend, maco,volume). The extension works fine for a normal country dimension but i want it to drill down for the hierarchical dimension, i.e; when I click on the country label, it should get the brands for that country and repaint the chart. Similarly when i click on the brand it should get the mixtures for that brand.</P><P></P><P>I am confused as to what should go as a parameter to the backendApi.selectvalues() function.I have the dinKeys for each object.<IMG alt="stackedGroup.PNG" class="jive-image image-1" height="238" src="https://community.qlik.com/legacyfs/online/185693_stackedGroup.PNG" style="height: 238.306px; width: 394px;" width="394" /></P></BODY></HTML> Tue, 05 Dec 2017 07:13:37 GMT Anonymous 2017-12-05T07:13:37Z How to get the next level data for a hierarchical dimension? https://community.qlik.com/t5/Integration-Extension-APIs/How-to-get-the-next-level-data-for-a-hierarchical-dimension/m-p/1425607#M8887 <HTML><HEAD></HEAD><BODY><P>I am writing a stacked group d3 extension which accepts a hierarchical dimension (Country&gt; brand&gt; mixture) and year dimension and three measures (spend, maco,volume). The extension works fine for a normal country dimension but i want it to drill down for the hierarchical dimension, i.e; when I click on the country label, it should get the brands for that country and repaint the chart. Similarly when i click on the brand it should get the mixtures for that brand.</P><P></P><P>I am confused as to what should go as a parameter to the backendApi.selectvalues() function.I have the dinKeys for each object.<IMG alt="stackedGroup.PNG" class="jive-image image-1" height="238" src="https://community.qlik.com/legacyfs/online/185693_stackedGroup.PNG" style="height: 238.306px; width: 394px;" width="394" /></P></BODY></HTML> Tue, 05 Dec 2017 07:13:37 GMT https://community.qlik.com/t5/Integration-Extension-APIs/How-to-get-the-next-level-data-for-a-hierarchical-dimension/m-p/1425607#M8887 Anonymous 2017-12-05T07:13:37Z