Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagarrahul
Creator
Creator

sum problem

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 .

12 Replies
Kushal_Chawda

Create table

Dimension:

icdcode_alha

Expression:

=if(sum(Icdcode_num)>0.7,'Outlier','not Outlier')

sagarrahul
Creator
Creator
Author

Kush141087 thank you for ur help

but if we have do count function with inline function on this then how to do it .

Not applicable

COUNT({$

<Icdcode_num = {'=SUM(Icdcode_num)>0.7'}>

} Icdcode_alpha)

Set Analysis: syntaxes, examples

Gysbert_Wassenaar

What's an 'inline function' ?


talk is cheap, supply exceeds demand
sagarrahul
Creator
Creator
Author

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

Gysbert_Wassenaar

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.


talk is cheap, supply exceeds demand
Kushal_Chawda

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

];

sagarrahul
Creator
Creator
Author

kush141087 just want count not sum

sagarrahul
Creator
Creator
Author

sry not sum just count want to do it count and if it goes beyond >0.7 then oulier