Stacked Bar to Linear Gauge Ruler Chart

[#1]

Hi Friends,

I need your help here.

On the image shown above, i have created a stacked bar chart.

I need to make a linear gauge chart ruler similar to this.

Is this possible in qlikview?

I did try making a gauge chart but it was not coming with the desired results.

Thanks in advance.

Regards,

Kuldeep

[anguila]

You should store each  expression in the right variable..

v0_30=Count({<[Age] = {'0-30'}>}[Age])/Count([Age])

v31_60=Count({<[Age] = {'31-60'}>}[Age])/Count([Age])

....

You also need to change the max of the gauge, with the sum of all the expressions v0_30+v31_60+...

Regards,

[#3]

Hey David,

This is what exactly i did. But was not getting the results.

Regards,

Kuldeep

[anguila]

Could you provide the file with an example of what you're using?

[#5]

Hi David,

Attached file for your reference.

Regards.

Kuldeep

[anguila · Accepted solution]

You missed the '=', in the variable, so you were storing text, no the value of the expression (you could also use the $(expression) to calculate it)

=Count({<[Age] = {'0-30'}>}[Age])/Count([Age])

I attach you the file with this issue fixed

Kind regards,

[#7]

Thanks David.

This is perfect. Exactly what i need

Regards,

Kuldeep