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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to display count of member id base on -ve value of metrics of straight table

Hi,

We have try to display total count member id into text box object  of those employee who have not complete goal  means goal variance(Average Hrs – Billable forecast) < 0  or  >0.

We use expression  but it is not counting value :-

  =Count(
  Aggr(
  if((SUM({<%CompanyRecID_Key={'*'}-{250},
  TE_Inactive_Flag={'0'},
  TE_Utilization_Flag={'-1'},
  MemberID = {'*'}-{'Consulting'},
  ME_Member_Class={'F'}>}[Hours Bill])
  /Num(vUtilizationmaxdayofmonth*8)) > TE_Billable_Forecast, MemberID
  )
  ,MemberID
  )
  )



Please suggest solution of this problem

1 Reply
anbu1984
Master III
Master III

Can you attach sample app