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

[buzzy996]

try this way,

tab5:

LOAD * INLINE [

Dim,agegroup,sales

agegroup,0-30,60

agegroup,31-60,20

agegroup,61-90,10

agegroup,90+,6

];

[#3]

Hi Shiva,

I am sorry, i think i was not much clear .

I can make the bar chart, its just that i need to convert it into linear gauge ruler.

Regards,

Kuldeep

[anguila]

Sure.

Please, find the attached example.

You can replace the variables by fields if needed.

Kind regards,

[#5]

Hey David,

That's cool.

Can you please help me with, how to create variables.

Regards,

Kuldeep

[anguila]

Hi,

Take a look here Creating variables in qlikview

You should search the community first after ask new questions, it's faster for you and it helps the Qlik community stay clear of repeated posts.

Kind regards,

[#7]

Hey thanks,

I am sorry. I did figured out myself.

Will try by myself with my data.

Regards,

Kuldeep

[anguila]

If you think the answer provided is right, could you mark it as answered?

Regards,

[#9]

Hey David,

No, i haven't got the solution yet.

In your example, you have assigned values directly to your variable.

I need to calculate it using a formula like count(A)/count(B), which will be stored in a variable.

Then when i am summing it up in the segment section, i am not getting desired results.

Regards,

Kuldeep

[#10]

Hi friends,

I have attached excel sheet for your reference.

I want a linear gauge ruler chart for which i was using expressions:

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

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

Count({<[Age] = {'61-90'}>}[Age])/Count([Age])

Count({<[Age] = {'90+'}>}[Age])/Count([Age])

Regards,

KuldeepAttachments