Gauge chart values need to show in Percentage

[Eshwar1]

Hi All,

I am trying create a Gauge chart using below expression

Sum({<Category={'XYZ'},Date={">=$(=MonthStart(Max(Date)))<=$(=Max(Date))"}>}Value)/Count(Distinct Month)

its showing number, instead i want to show in Percentage like ex: 22.88%

tried below expression

Num((Sum({<Category={'XYZ'},,Date={">=$(=MonthStart(Max(Date)))<=$(=Max(Date))"}>}Value)/Count(Distinct Month)),'#,##0.00%')

it is showing big value like -:  22,345,56.00%

Can any one suggest how to achieve.

Thanks in advance

-Eshwar

[F_B]

Hi, you can set your expression

Sum({<Category={'XYZ'},Date={">=$(=MonthStart(Max(Date)))<=$(=Max(Date))"}>}Value)/Count(Distinct Month)

and then, in the properties panel of the chart, customize the number format as percentage.

Hope this can help you, bye.

[Eshwar1]

Hi F_B

did that but it is showing big value like -:  22,345,56.00%

can u suggest any other solution.

[F_B]

Hello Eshwar1,

I made a test with a simple dataset and it works, I just had to add a division by 100 to get the right size of the measure:

Sum({<Category={'XYZ'},Date={">=$(=MonthStart(Max(Date)))<=$(=Max(Date))"}>}Value)/Count(Distinct Month)/100

There are 2 things that I think you can check:

1. "Month" is also a Qlik function, so be sure that you are referring to the field "Month" in your expression (after Distinct).

2. Maybe there are wrong values in your dataset.

Hope this helps, bye

[F_B]

Hi @Eshwar1 ,

did you solve your problem?