topic Re: Stacked Bar to Linear Gauge Ruler Chart in QlikView

Stacked Bar to Linear Gauge Ruler Chart

Thu, 16 Apr 2015 13:13:28 GMT

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

Re: Stacked Bar to Linear Gauge Ruler Chart

buzzy996 — Thu, 16 Apr 2015 13:23:00 GMT

try this way,

tab5:

LOAD * INLINE [

Dim,agegroup,sales

agegroup,0-30,60

agegroup,31-60,20

agegroup,61-90,10

agegroup,90+,6

];

Re: Stacked Bar to Linear Gauge Ruler Chart

Thu, 16 Apr 2015 13:35:07 GMT

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

Re: Stacked Bar to Linear Gauge Ruler Chart

anguila — Thu, 16 Apr 2015 13:37:31 GMT

Sure.

Please, find the attached example.

You can replace the variables by fields if needed.

Kind regards,

Re: Stacked Bar to Linear Gauge Ruler Chart

Thu, 16 Apr 2015 13:39:37 GMT

Hey David,

That's cool.

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

Regards,

Kuldeep

Re: Stacked Bar to Linear Gauge Ruler Chart

anguila — Thu, 16 Apr 2015 13:46:21 GMT

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,

Re: Stacked Bar to Linear Gauge Ruler Chart

Thu, 16 Apr 2015 13:52:09 GMT

Hey thanks,

I am sorry. I did figured out myself.

Will try by myself with my data.

Regards,

Kuldeep

Re: Stacked Bar to Linear Gauge Ruler Chart

anguila — Thu, 16 Apr 2015 14:11:11 GMT

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

Regards,

Re: Stacked Bar to Linear Gauge Ruler Chart

Thu, 16 Apr 2015 14:17:58 GMT

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

Re: Stacked Bar to Linear Gauge Ruler Chart

Thu, 16 Apr 2015 15:07:27 GMT

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

Re: Stacked Bar to Linear Gauge Ruler Chart

anguila — Thu, 16 Apr 2015 15:44:38 GMT

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,

Re: Stacked Bar to Linear Gauge Ruler Chart

Fri, 17 Apr 2015 07:57:18 GMT

Hey David,

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

Regards,

Kuldeep

Re: Stacked Bar to Linear Gauge Ruler Chart

anguila — Fri, 17 Apr 2015 13:48:12 GMT

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

Re: Stacked Bar to Linear Gauge Ruler Chart

Fri, 17 Apr 2015 15:29:57 GMT

Hi David,

Attached file for your reference.

Regards.

Kuldeep

Re: Stacked Bar to Linear Gauge Ruler Chart

anguila — Fri, 17 Apr 2015 15:50:27 GMT

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,

Re: Stacked Bar to Linear Gauge Ruler Chart

Mon, 20 Apr 2015 05:22:06 GMT

Thanks David.

This is perfect. Exactly what i need

Regards,

Kuldeep