Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Kaushik2020
Creator III
Creator III

Calculate measure based on Blocked and Null values

Dear All, 

I am reading data from Excel where we have below details. Is there a way to calculate Average and count based on the below mentioned logics ? 

ID NAME Salary Designation Q1-Rating Q2-Rating Q3-Rating Q4-Rating Yearly Average Rating Count
1 A 10000 Tester Blocked Blocked 5 4 calculate based on Q3 and Q4 Count of Quarters where we have a data
2 B 20000 Developer 3 Blocked Blocked 4 Calculate based on Q1 and Q4 Count of Quarters where we have a data
3 C 15000 Lead 3 5 4 4 Calculate based on all quarters Count of Quarters where we have a data
4 D 20000 Manager 5 5 Blocked Blocked Calculate based on Q1 and Q2 Count of Quarters where we have a data

 

 

Labels (3)
2 Replies
Chanty4u
MVP
MVP

Hi 

What is your expected output 

Kaushik2020
Creator III
Creator III
Author

thanks for your reply. Please refer the last 2 columns for the same. Feel free to revert in case anything.