Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

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

Re: Percentage calculation on the speedometer dial chart

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

Re: Percentage calculation on the speedometer dial chart

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

Re: Percentage calculation on the speedometer dial chart

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

=Sum(VL_Credito)/Count(DISTINCT SiglaArea)

Community Browser