Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Paknanarn23
Creator II
Creator II

How do I get the average from this code?

I want to find the total average from this code, how do I do that?

Paknanarn23_0-1678865910046.png

 

2 Replies
MayilVahanan

Hi

Might be, try like below

Avg(Aggr(urexp, urdimension))

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Paknanarn23
Creator II
Creator II
Author

Hi 
This is not what I want I want to find the AVg value. into this recipe

1-Count({<ST_Status = {'Failed'},MO_OrderType1 = {'ZM*1' ,'ZM*2'}>}DISTINCT MO_OrderNo)/(count({<MO_OrderType = {'ZM*1',' ZM*2'} , ST_Status = {'Completed'}>}DISTINCT MO_OrderNo)+ Count({<ST_Status = {'Failed'},MO_OrderType1 = {'ZM*1' ,'ZM*2'}>}DISTINCT MO_OrderNo ))