topic PROBLEM TO CALCULATE MEDIA, MEDIANA AND DEV STD in QlikView

PROBLEM TO CALCULATE MEDIA, MEDIANA AND DEV STD

gabroteddy — Mon, 30 Jul 2018 06:38:59 GMT

When i have a lot of data i must take the Media, Mediana and Standard

Deviation of all case.

I attach the dashboard that i have in output.

What i want do is calculate the media, mediana and devstd of only the ID

where the interval is correctly calculate (sometime is not valorized)...if

is possible in a separate dashboard.

Solutions???

BalaBhaskar_Qlik — Mon, 30 Jul 2018 08:20:22 GMT

Median & Std Dev calculation may be like this:

=Median({<[Patient Test] = {'Test1', 'test2'}>}

Aggr(Count({<TestList = {'Test1', 'Test2'} >} PatientNumber),PatientNumbea)

)

=Stdev(aggr(sum(Revenue),Desk, Day))

=Stdev(Aggr(Sum([LV_M-Abgang-Gesamt]), Division, Lagerort, Artikelgruppe, [LV_JahrMonat/YearMonth]))

gabroteddy — Mon, 30 Jul 2018 08:42:55 GMT

Hi Bala,

can you explain better the formula?

I do not understand what information i must utilize....can you utililze th field present in my dashboard to explain me how i can compile the formula?

Thx

BalaBhaskar_Qlik — Mon, 30 Jul 2018 10:35:24 GMT

Think so some thing like this:

=Median({<PROVA1_ORA=,PROVA2_ORA=>}

Aggr(Count({<PROVA1_ORA=,PROVA2_ORA=>}ID),PROVA2_DATA,PROVA1_DATA)

)

=Stdev(Aggr(Sum(PROVA1_ORA),ID,PROVA1_DATA)) + Stdev(Aggr(Sum(PROVA2_ORA),ID,PROVA2_DATA))