Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Champion III
Champion III

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
Highlighted

Re: RE:Ration

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

Regards

Anand

Highlighted
Creator III
Creator III

Re: RE:Ration

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

Highlighted

Re: RE:Ration

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

Highlighted
Champion
Champion

Re: RE:Ration

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)

Highlighted
Master
Master

Re: RE:Ration

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

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