Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

simbai94
New Contributor

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
MVP
MVP

Re: Expression Query

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
New Contributor

Re: Expression Query

Thank you Steven. Let me give this a go!

simbai94
New Contributor

Re: Expression Query

Sorry. Thank you Stefan!

Community Browser