Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Percentage calculation on the speedometer dial chart

Good morning, my database has the VL_Credito fields, SiglaArea and Curso_Edicao like to with this information generate a speedometer chart and the percentage rate in half; data

VL_Credito SiglaArea Curso_Edicao

R $ 495,080.00 DG Specialization in Management PUBLIC POLICIES OF CULTURE - 01/2006

R $ 495,080.00 DG Specialization in Management PUBLIC POLICIES OF CULTURE - 01/2006

R $ 495,080.00 DG Specialization in Management PUBLIC POLICIES OF CULTURE - 01/2006

R $ 495,080.00 DG Specialization in Management PUBLIC POLICIES OF CULTURE - 01/2006

R $ 495,080.00 DG Specialization in Management PUBLIC POLICIES OF CULTURE - 01/2006

R $ 280,000.00 DCT ENGLISH - 01/2011

R $ 280,000.00 DCT ENGLISH - 01/2011

R $ 280,000.00 DCT ENGLISH - 01/2011

R $ 280,000.00 DCT ENGLISH - 01/2011

R $ 280,000.00 FAC ENGLISH - 01/2011

R $ 280,000.00 FAC ENGLISH - 01/2011

R $ 280,000.00 FAC ENGLISH - 01/2011

R $ 280,000.00

FAC

ENGLISH - 01/2011

My calculation for the chart looked like this:

Expression: count (VL_Credito) / Count (Name)

In a field of graph = Text (Sum (VL_Credito) / Count (Name) / Count (Curso_Edicao), '# 0%')

when generate the graph the percentage value does not work correctly when I select one of SilgaArea

3 Replies
sunny_talwar

What is the expected value when you select one of SilgaArea? In addition are you getting correct results when nothing is selected?

To me it seems that Expression: count (VL_Credito) / Count (Name) will always give you 1 unless you have a null value for one of those.

Please provide more details to help you resolve the issue.

Best,

Sunny

Not applicable
Author

VL_Credito the field is decimal , the SilgaArea and Curso_Edicao are text fields , I want Vazer the sum of VL_Credito divided by SiglaArea which are three DCT , DG and FAC , by the time I select a destars SiglaAreas the clock give me the percentage value by SiglaArea said

sunny_talwar

still not 100% certain, but see if this gets you to where you want to go:

=Sum(VL_Credito)/Count(DISTINCT SiglaArea)