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