Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
I have a graph with no dimensions and three measures (called 1, 2 and 3).
Qlikview automatically creates a legend for me and multicolors the bars and legend, as shown in the image as Current.
However in this particular case I would like the name of the measure to appear below the bar just as dimension values would and have all the bars the same color, as shown in the image as Desired.
Is this possible and if so, can anybody tell me how?
Thanks in advance for all your help,
Mike
The chart needs a dimension for the X-axes. You can create an artificial dimension as logical island which contains, for your example, values 1, 2, and 3. And the expression will be:
if(BarDimension=1, <expression for measure 1>,
if(BarDimension=2, <expression for measure 2>,
if(BarDimension=3, <expression for measure 3>)))
The chart needs a dimension for the X-axes. You can create an artificial dimension as logical island which contains, for your example, values 1, 2, and 3. And the expression will be:
if(BarDimension=1, <expression for measure 1>,
if(BarDimension=2, <expression for measure 2>,
if(BarDimension=3, <expression for measure 3>)))