topic Re: How to design a gauge chart with margin & margin % as given below. in QlikView

How to design a gauge chart with margin & margin % as given below.

Tue, 11 Aug 2015 19:06:27 GMT

Expressions

Sum(Margin) for Margin

Sum(Margin)/Sum(Sales) for Margin %.

The attachment 1 shows the original solution but I don't have the properties of it.

Where as attachment 2 shows the chart I got. vinay_bangari‌

Re: How to design a gauge chart with margin & margin % as given below.

Anonymous — Tue, 11 Aug 2015 19:31:58 GMT

Hi Nithin,

In Expression tab of gauge chart properties give the

an expression - Sum(Margin)/Sum(Sales)

Number Tab:

select integer

and select show as percent checkbox

Presentation tab:

assign Min = 0

Max = 100

Create 3 segments

Segment 1 = 0 //Colour Red

Segment 2 = 80 //Colour Amber

Segment 3 = 90 //Colour Green

For text give the expression for metrics you want to show.

Regards

Neetha

Re: How to design a gauge chart with margin & margin % as given below.

maxgro — Tue, 11 Aug 2015 19:34:34 GMT

like this?

Re: How to design a gauge chart with margin & margin % as given below.

Anonymous — Tue, 11 Aug 2015 20:03:06 GMT

go to the properties of the chart select Min and Max as per your requirement, select the checkbox -show as percentage and then give the coloring in segments assigning each segment a particular color.

Re: How to design a gauge chart with margin & margin % as given below.

Bill_Britt — Tue, 11 Aug 2015 20:41:47 GMT

HI,

Here is an example. It is very basic.

Posters, it is a big help for people if you would take the time to create a sample for them to see. The information you have given is good, but it also helps for them to see what you are doing.

Bill

Re: How to design a gauge chart with margin & margin % as given below.

Anonymous — Wed, 12 Aug 2015 18:32:11 GMT

see the attached word document which will help you to solve the issue.

Re: How to design a gauge chart with margin & margin % as given below.

Anonymous — Wed, 12 Aug 2015 22:10:50 GMT

heere is the attachment