Hi team

[Kohli]

Hi have a bar chart with comparison between the open and closed products.. and product dth, tv, fridge, laptop. I want show the chart comparison between the open and close and show the graph ascending order based on closed item not in alphabet format in qliksense.

[marcginqo]

Hi,

In Sense go to edit mode of the sheet. Select the Bar Chart en look at the properties window on the right side.

Choose your dimension field and expand it. Deselect Auto sorting and check Sort by expression. Put in your calculation for the Closed items and choose Descending or Ascending. Uncheck the other options if you don't want to sort on these too.

Hope this helps.

Marc