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: 
VishalSingh18
Contributor III
Contributor III

Formulating a Expression

Hello,

I need to develop a expression that respects the below condition

Definition: Number of items completed 100% / total number of items per route by date

Numerator: Total Items completed 100%

              Where ifnull(qty,0)>=ifnull(reqqty,0)

              In this example, we would count the records in blue as “loaded 100%”(that means qty>=reqqty) and we will record 14 as the numerator

Denominator

              Count(item)…….where date={date} and route={route} and item is not null

Final Result

              For this example, we would calculate 14/20 = .7 or 70%

Labels (2)
1 Reply
VishalSingh18
Contributor III
Contributor III
Author

its done problem was resolved