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 |
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 .
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 .
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;
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
];
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