https://community.qlik.com/t5/App-Development/How-to-create-a-bar-chart-with-x-axis-showing-product-name-for/m-p/2436095#M97022 <P>Hi!</P> <P>I have a bar chart with a ranking of products by #orders</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ccaporaso_0-1711915298057.png" style="width: 665px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/163055i260C571E13F74F61/image-dimensions/665x509?v=v2" width="665" height="509" role="button" title="ccaporaso_0-1711915298057.png" alt="ccaporaso_0-1711915298057.png" /></span></P> <P>My customer wants that, when he selects a Company, the products related to that Company keep the product name on the X axis, but products from other companies change from product name to the product position in the overall ranking.</P> <P>For example: If I select Company1, the chart is displayed in this way:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ccaporaso_1-1711915500030.png" style="width: 496px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/163056iBA2543E73C785FCB/image-dimensions/496x557?v=v2" width="496" height="557" role="button" title="ccaporaso_1-1711915500030.png" alt="ccaporaso_1-1711915500030.png" /></span></P> <P>But my customer wants a chart similar to the one sketched below:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ccaporaso_2-1711915765251.png" style="width: 627px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/163057i18104D0DD48C8A53/image-dimensions/627x469?v=v2" width="627" height="469" role="button" title="ccaporaso_2-1711915765251.png" alt="ccaporaso_2-1711915765251.png" /></span></P> <P>The real case is a bit more complex, but I'm facing some problems trying to get this behavior without generating dimensions using scripting. I'd prefer using a dynamic dimension in the chart (number of records is not an issue)</P> <P>Environment is Qlik Sense Cloud. I'm attaching a sample qvf.</P> <P>Any suggestion?</P> <P><SPAN>Thanks in advance!<BR /><BR />Kind regards,</SPAN></P> <P><SPAN>Cecilia.&nbsp;</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 31 Mar 2024 20:19:09 GMT ccaporaso 2024-03-31T20:19:09Z https://community.qlik.com/t5/App-Development/How-to-create-a-bar-chart-with-x-axis-showing-product-name-for/m-p/2436095#M97022 <P>Hi!</P> <P>I have a bar chart with a ranking of products by #orders</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ccaporaso_0-1711915298057.png" style="width: 665px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/163055i260C571E13F74F61/image-dimensions/665x509?v=v2" width="665" height="509" role="button" title="ccaporaso_0-1711915298057.png" alt="ccaporaso_0-1711915298057.png" /></span></P> <P>My customer wants that, when he selects a Company, the products related to that Company keep the product name on the X axis, but products from other companies change from product name to the product position in the overall ranking.</P> <P>For example: If I select Company1, the chart is displayed in this way:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ccaporaso_1-1711915500030.png" style="width: 496px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/163056iBA2543E73C785FCB/image-dimensions/496x557?v=v2" width="496" height="557" role="button" title="ccaporaso_1-1711915500030.png" alt="ccaporaso_1-1711915500030.png" /></span></P> <P>But my customer wants a chart similar to the one sketched below:</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ccaporaso_2-1711915765251.png" style="width: 627px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/163057i18104D0DD48C8A53/image-dimensions/627x469?v=v2" width="627" height="469" role="button" title="ccaporaso_2-1711915765251.png" alt="ccaporaso_2-1711915765251.png" /></span></P> <P>The real case is a bit more complex, but I'm facing some problems trying to get this behavior without generating dimensions using scripting. I'd prefer using a dynamic dimension in the chart (number of records is not an issue)</P> <P>Environment is Qlik Sense Cloud. I'm attaching a sample qvf.</P> <P>Any suggestion?</P> <P><SPAN>Thanks in advance!<BR /><BR />Kind regards,</SPAN></P> <P><SPAN>Cecilia.&nbsp;</SPAN></P> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Sun, 31 Mar 2024 20:19:09 GMT https://community.qlik.com/t5/App-Development/How-to-create-a-bar-chart-with-x-axis-showing-product-name-for/m-p/2436095#M97022 ccaporaso 2024-03-31T20:19:09Z