Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
ccaporaso
Partner - Contributor III
Partner - Contributor III

How to create a bar chart with x axis showing product name for some bars and ranking for others

Hi!

I have a bar chart with a ranking of products by #orders

ccaporaso_0-1711915298057.png

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

But my customer wants a chart similar to the one sketched below:

ccaporaso_2-1711915765251.png

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. 

 

 

 

Labels (1)
  • SaaS

0 Replies