topic Re: Measure as Dimension in App Development

Measure as Dimension

danimelo1 — Sun, 03 Dec 2017 13:18:33 GMT

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

Re: Measure as Dimension

Anonymous — Sun, 03 Dec 2017 13:51:26 GMT

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

Re: Measure as Dimension

luismadriz — Sun, 03 Dec 2017 23:13:34 GMT

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