Hi!
I have a bar chart with a ranking of products by #orders
![ccaporaso_0-1711915298057.png ccaporaso_0-1711915298057.png](https://community.qlik.com/t5/image/serverpage/image-id/163055i260C571E13F74F61/image-dimensions/665x509?v=v2)
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.
For example: If I select Company1, the chart is displayed in this way:
![ccaporaso_1-1711915500030.png ccaporaso_1-1711915500030.png](https://community.qlik.com/t5/image/serverpage/image-id/163056iBA2543E73C785FCB/image-dimensions/496x557?v=v2)
But my customer wants a chart similar to the one sketched below:
![ccaporaso_2-1711915765251.png ccaporaso_2-1711915765251.png](https://community.qlik.com/t5/image/serverpage/image-id/163057i18104D0DD48C8A53/image-dimensions/627x469?v=v2)
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)
Environment is Qlik Sense Cloud. I'm attaching a sample qvf.
Any suggestion?
Thanks in advance!
Kind regards,
Cecilia.