Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
2.8
2.7
2.6
2.5
2.4
2.3
S
43.3
43.2
43.1
43
42.9
42.8
42.7
42.4
42.3
42.2
42.1
help me in dis as i m new on qlikview .
Create table
Dimension:
icdcode_alha
Expression:
=if(sum(Icdcode_num)>0.7,'Outlier','not Outlier')
Kush141087 thank you for ur help
but if we have do count function with inline function on this then how to do it .
COUNT({$
<Icdcode_num = {'=SUM(Icdcode_num)>0.7'}>
} Icdcode_alpha)
Set Analysis: syntaxes, examples
What's an 'inline function' ?
LOAD * 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
];
in this way do direct data adding
And what does 'i want do sum on this and if there sum goes beyond >0.7' mean? All values are larger than 0.7.
I am still not clear but do you want this
Data:
Load *,
if(Sum_Icdcode>0.7,'outlier','not outlier') as Flag;
Icdcode_alpha ,
Count(Icdcode_alpha) as Count_Icdcode,
Sum(Icdcode_num) as Sum_Icdcode
Group by Icdcode_alpha;
kush141087 just want count not sum
sry not sum just count want to do it count and if it goes beyond >0.7 then oulier
