sum problem

[sagarrahul]

hii

i have two column in below tableie icdcode_alha and icdcode_num .

i want do sum on this and if there sum goes beyond >0.7 then its an 'outlier' if not then its 'not outlier'

(i want to use if condition and inline function)

Icdcode_alpha	Icdcode_num
T	2.9
T	2.8
T	2.7
T	2.6
T	2.5
T	2.4
T	2.3
S	43.3
S	43.2
S	43.1
S	43
S	42.9
S	42.8
S	42.7
S	42.4
S	42.3
S	42.2
S	42.1

help me in dis as i m new on qlikview .

[Kushal_Chawda]

the use  Count_Icdcode in IF condition instead of Sum

[Gysbert_Wassenaar]

All values are larger then 0.7.

T1:

LOAD *, if(Icdcode_num>0.7,1,0) as Counter INLINE [

Icdcode_alpha , Icdcode_num

T, 2.9

T, 2.8

T, 2.7

T, 2.6

T, 2.5

T, 2.4

T, 2.3

S, 43.3

S, 43.2

S, 43.1

S, 43

S, 42.9

S, 42.8

S, 42.7

];

T2:

LOAD

     sum(Counter) as CountOfOutliers

RESIDENT

     T1

     ;

[Anonymous]

count({<Icdcode_num={'=Sum(cdcode_num)>0.7'}>}Icdcode_alpha)