Discussion board where members can get started with QlikView.
I using this in front in simple table :
What dimensions do you have?
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) )))))))))))))))
Try adding TOTAL and see if that works
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
What is strange about having an average of 425.03 and stdev of 133.45? What do you think it should be?
I just did not calculate well by my side...
Sorry for my mistake.
Thanks a lot for your help Sunny !
Great week end,