topic help for KPI in App Development

help for KPI

adminkare — Tue, 02 Oct 2018 10:58:16 GMT

Hi help me pls,

I want to try for KPI a example. I want to see the sum of those with a value of 1. How will i do?

Calculation for B:

if(sum(Aggr(SUM({<secim_no={"8"}>}[AK PARTİ]), A ))

sum(Aggr(SUM({<secim_no={"8"}>}CHP), A ))

,1,0)

Re: help for KPI

sunny_talwar — Tue, 02 Oct 2018 14:50:25 GMT

May be this

Sum(Aggr(If(Sum(Aggr(Sum({<secim_no={"8"}>} [AK PARTİ]), A)) > Sum(Aggr(Sum({<secim_no={"8"}>} CHP), A)), 1, 0), Chart_Dimension_Here))

Re: help for KPI

adminkare — Tue, 02 Oct 2018 17:57:35 GMT

its ok! perfect.. Thank u sir...

Re: help for KPI

adminkare — Wed, 03 Oct 2018 12:13:55 GMT

Hi sir,

So how do I give the color this Chart?

Re: help for KPI

sunny_talwar — Wed, 03 Oct 2018 12:20:15 GMT

Color to this chart? Have you mistakenly posted your question on this thread? I see no reference of any chart here... we were working on a KPI object here....

Re: help for KPI

adminkare — Wed, 03 Oct 2018 12:44:36 GMT

Oh ok. sorry..

I try code in Chart graph too... and its work...

Sum(Aggr(If(Sum(Aggr(Sum({<secim_no={"8"}>} [AK PARTİ]), A)) > Sum(Aggr(Sum({<secim_no={"8"}>} CHP), A)), 1, 0), Chart_Dimension_Here))

So how do I give the color this Chart?

Re: help for KPI

sunny_talwar — Wed, 03 Oct 2018 13:06:32 GMT

I will have to test it out... would you be able to share a sample?

Re: help for KPI

adminkare — Wed, 03 Oct 2018 13:24:53 GMT

Ok sir. 1st and 2nd colums :

1st column:

Sum(Aggr(

if(

(sum(Aggr(SUM({<secim_no={"8"}>}[AK PARTİ]),[İL ADI],[SANDIK NO],[İLÇE_ADI],MAHALLE_ADI,secim_no,[sandık no san],[ilçe mah]))

sum(Aggr(SUM({<secim_no={"8"}>}CHP),[İL ADI],[SANDIK NO],[İLÇE_ADI],MAHALLE_ADI,secim_no,[sandık no san],[ilçe mah])))

,1,0)

, [İLÇE_ADI]))

2nd column:

if(

(sum(Aggr(SUM({<secim_no={"6"}>}[AK PARTİ]),[İL ADI],[SANDIK NO],[İLÇE_ADI],MAHALLE_ADI,secim_no,[sandık no san],[ilçe mah]))

sum(Aggr(SUM({<secim_no={"6"}>}CHP),[İL ADI],[SANDIK NO],[İLÇE_ADI],MAHALLE_ADI,secim_no,[sandık no san],[ilçe mah])))

,1,0)

, [İLÇE_ADI]))

i tried this:

if((Sum(Aggr(

Sum(Aggr(

if(

(sum(Aggr(SUM({<secim_no={"8"}>}[AK PARTİ]),[İL ADI],[SANDIK NO],[İLÇE_ADI],MAHALLE_ADI,secim_no,[sandık no san],[ilçe mah]))

sum(Aggr(SUM({<secim_no={"8"}>}CHP),[İL ADI],[SANDIK NO],[İLÇE_ADI],MAHALLE_ADI,secim_no,[sandık no san],[ilçe mah])))

,1,0)

, [İLÇE_ADI]))

, [İL ADI],[İLÇE_ADI]))),'blue','orange')

but Painted in blue in 2 columns.:(((

Re: help for KPI

sunny_talwar — Wed, 03 Oct 2018 13:30:33 GMT

I was looking for a sample qvf as this doesn't give me the option to see settings you have and also doesn't allow me to test anything out

Re: help for KPI

adminkare — Wed, 03 Oct 2018 13:44:53 GMT

ok i understood you sir. I created a *.qvf .. but i dont add here??

how will I do? help me pls

Re: help for KPI

sunny_talwar — Wed, 03 Oct 2018 13:56:15 GMT

Check here

Uploading a Sample

Re: help for KPI

adminkare — Wed, 03 Oct 2018 15:10:22 GMT

Ok sir.. ist ok.

ornek.qvf

thank you

Re: help for KPI

adminkare — Tue, 09 Oct 2018 13:04:24 GMT

Sir help me pls:(