Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

axel_bgd
Contributor II

Re: Condition

I using this in front in simple table :

Re: Condition

What dimensions do you have?

axel_bgd
Contributor II

Re: Condition

many I took valuelist rowno ..

in total 15 but I want just  the deviation regarding each field : but the result means not good

=if(rowno()=1,Stdev([Age du patient]),

if(rowno()=2,'',

if(rowno()=3,Stdev(TDM_E1_DIST_PARCOURUE_M94),

if(rowno()=4,Stdev(TDM_E1_O2_DEBIT_DUPLIV277),

if(rowno()=5,Stdev(CSV_TDM_E2_DIST_PARCOURUE_DUPLI24),

if(rowno()=6,Stdev(CSV_TDM_E2_ENTREE_DEBITO2_DUPLI76),

if(rowno()=7,Stdev(TDM_BILAN_DISTANCE_PARCOURUE_ENTREE40),

if(rowno()=8,Stdev(TDM_BILAN_DYSPNEE_FIN_TEST_ENTREE_V268),

if(rowno()=9,'',

if(rowno()=10,Stdev(CSV_TDM_SORTIE_DISTANCE_PARCOURUE65),

if(rowno()=11,Stdev(CSV_TDM_SORTIE_DBIT_DUPLI79),

if(rowno()=12,'',

if(rowno()=13,Stdev(CSV_TDM_BILAN_DIFFER_DISTANC_ENTRE_SORT57),

if(rowno()=14,Stdev(CSV_TDM1_DYSPNEEDELTA110),

if(rowno()=15,Stdev(CSV_TDM_SORTIE_DYSPNE_653) )))))))))))))))

Re: Condition

Try adding TOTAL and see if that works

axel_bgd
Contributor II

Re: Condition

I tried and it's change nothing maybe I need to arrange something ...

Because it look extrange when the average it 425.03 and the deviation 133.45

Re: Condition

What is strange about having an average of 425.03 and stdev of 133.45? What do you think it should be?

axel_bgd
Contributor II

Re: Condition

Hi Sunny,

I just did not calculate well by my side...

Sorry for my mistake.

Thanks a lot for your help Sunny !

Great week end,

Axel