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

RE:Ration

hi,

am using pie chart expresions...

what wrong in my expression while caluculating the  Def density

=(count( ref_ID)-sum(if(ref_Status='Dump' or reff_Status='Withd' or ref_Status='Rej',1,0)

/count(estatus='Passed')

Aceptance rate

=(count( ref_ID)-sum(if(ref_Status='Dump' or ref_Status='Withd' or ref_Status='Rej',1,0)

/count(ref_id)

please help me out...where am wrong

thanks in advance

Suresh

5 Replies
its_anandrjs

Your expression is wrong can you explain with fields and flag fields in the formula that you want to achieve.

Regards

Anand

roger_stone
Creator III
Creator III

Names are case-sensitive and you have also misspelt one in your example.

its_anandrjs

Try this once or provide sample data file

I assume here that you want to subtract that value which contains ref_Status='Dump' or ref_Status='Withd' or ref_Status='Rej'

=(count(ref_ID)   -   sum(if(ref_Status='Dump' or ref_Status='Withd' or ref_Status='Rej',1,0))

  /

  count(ref_id))

Regards

Anand

Anonymous
Not applicable

may be this:

=(count( ref_ID) - sum(if(ref_Status='Dump' or reff_Status='Withd' or ref_Status='Rej',1,0))

/

count({<estatus={'Passed'}>} ref_ID)

or try with distinct:

=(count(distinct ref_ID) - sum(if(ref_Status='Dump' or reff_Status='Withd' or ref_Status='Rej',1,0))

/

count({<estatus={'Passed'}>} distinct ref_ID)

effinty2112
Master
Master

This is maybe the most readable way to get the result you want:

Count({$<ref_Status -={'Dump','Withd',Rej'}>}ref_ID)/Count(ref_id)