Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

danimelo1
New Contributor III

Measure as Dimension

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

Tags (1)
1 Solution

Accepted Solutions
luismadriz
Valued Contributor

Re: Measure as Dimension

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.

Untitled.png

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

Cheers,

Luis

2 Replies
kpkumar
New Contributor III

Re: Measure as Dimension

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
Valued Contributor

Re: Measure as Dimension

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.

Untitled.png

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

Cheers,

Luis

Community Browser