Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 !
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
Hi Antoine,
Check this, give a new expression:
Jordy
Climber
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 !
Hi Antoine,
No problem, thank! @Bastien_Laugiero , is there a reason that he can't select this as a solution?
Jordy
Climber
Hi Antoine,
No problem, thanks! @Bastien_Laugiero , is there a reason that he can't select this as a solution?
Jordy
Climber
You are Welcome Glad to have helped