Check if this works for you. Some hardcode work needs to be done through
test.qvw 146.2 K
BlackRockS, your idea is interesting, thanks. I will work on it.
Martijn, I'm sorry, I don't understand your answer. How QV will associate Advancement labels on axis with bar length ? It takes number values to determine bar length. And if you give it number values, it will write them on the axis, not labels.
I've found something interesting in QV functions : dual() function, which associates a string representation with a given number representation. In this way, i've built a mapping table which associates Phase Label and Advancement. In my Project table, Dual() function associates these Phases label to their advancement in a single field "Phase" :
Dual (Phase_Label, ApplyMap('Advancement, Phase_Label)) as Phase,
I use this new field in the expression of my bar chart and this is what happens (see attached screenshot). QV uses number representation to calculate bar length and label value to describe bars. I still don't manage to display these labels on x-axis but i'm getting close to the solution.
Project_Advancement_2.JPG 30.0 K