How to sort a bar chart’s dimension by a measure not included in the chart

[Antoine]

Hello,

I don't know if it's possible or not, but I would like to order a chart with a measure that does not appear on it:

 The value in purple represents the gap between my main result and the target, and I want to use it to sort my chart, without actually displaying it. I've seen a thread about it on QLikview, but it doesn't seems to apply to Sense...

Thanks in advance for your support !

[anushree1]

On the sort section within the Dimension you have an option to sort based on expression (you may add the difference expression here), you could probably try that

[JordyWegman]

Hi Antoine,

Check this, give a new expression:

Jordy

Climber

[Antoine]

Thanks to both of you, that works perfectly !

Unfortunately, it seems I can't select your messages as a solution for some reason... (linking me to an page not found... (URL))

Have a good day and many thanks again !

[JordyWegman]

Hi Antoine,

No problem, thank! @Bastien_Laugiero , is there a reason that he can't select this as a solution?

Jordy

Climber

[JordyWegman]

Hi Antoine,

No problem, thanks! @Bastien_Laugiero , is there a reason that he can't select this as a solution?

Jordy

Climber

[anushree1]

You are Welcome Glad to have helped