Measure as Dimension

[danimelo1]

Hi Qlik experts,

I know the difference between measure and dimension. But is it possible to convert a measure into dimension? I need this because I want to put two measures in a bar char or stacked.

I have a measure name, Number of positions, and another measure named Number of position filled by talents employee. So I want to represent it as a bar char, so 1 bar would be the number of positions and the other one would be number of positions filled by talents employees, but of course as they are measures, I don't know how to convert or represent it as a bar chart.

Any ideas?

Regards

[Anonymous]

this may not be a solution, but you can try workaround like using a combo chart and presenting the desired measure in secondary Axis .

[luismadriz · Accepted solution]

Hola Daniel,

They still look like measures. If you want all positions and employees in a bar chart you could just put them there as measures and use a fake dimension such a word like ='Total' so you'll have both represented in a chart.

If I'm way off, please attached an image of what you'd like the chart to look like,

Cheers,

Luis