Qlik Community

Ask a Question

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Announcements
Do More with Qlik - for Beginners and Beyond, Topic: Qlik Replicate on January 21, 2PM EST. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Contributor III
Contributor III

its done problem was resolved