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: 
simbai94
Contributor II
Contributor II

Expression Query

DateAvailabilityStatusVendorTechID
1/01/20180.99BHuawei2GA0001
2/02/20180.98ASamsung3GA0002
25/01/20180.999BHuawei3GA0003
4/04/20180.97AHuawei2GA0004
7/04/20180.975ASamsung2GA0005
25/04/20180.99BSamsung2GA0006

Hie Guys. I would like to write an expression that will enable me to  count the number of 'ID's by 'Tech' and 'Vendor' which satisfy the condition that Count (Status = 'A' ) => 14 per month.     

Kindly Assist!!!

Thank you.

3 Replies
swuehl
MVP
MVP

Seems like you want to group your results by Tech and Vendor, so create a chart with two dimensions, Tech and Vendor.

Then use as expression:

=Sum( Aggr( If(Count({<Status = {'A'}>} Status) >= 14, 1,0), Tech, Vendor, ID))

simbai94
Contributor II
Contributor II
Author

Thank you Steven. Let me give this a go!

simbai94
Contributor II
Contributor II
Author

Sorry. Thank you Stefan!