Pareto diagram in Qlik Sense Comdo chart descending bars and ascending accumulated line

[Maaa]

Hi!

I need to convert this diagram in QlikView:

To  Qlik Sense. Unfortunately I cannot sort the bars descending and the accumulated values line ascending.

I have managed to add the bars and line but need to sort the bars descending and the line ascending.

Is this possible?

[Lisa_P · Accepted solution]

Yes, you will need to use an expression in the sorting to sort by dimension. Then use the same expression you have in your bar measure descending to get the sort to work.

[Maaa]

Perfect! Thank you so much 🙂