topic RE:Ration in QlikView

RE:Ration

Chanty4u — Tue, 08 Dec 2015 12:55:15 GMT

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

its_anandrjs — Tue, 08 Dec 2015 13:00:38 GMT

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

Regards

Anand

roger_stone — Tue, 08 Dec 2015 13:04:47 GMT

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

its_anandrjs — Tue, 08 Dec 2015 13:06:47 GMT

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 — Tue, 08 Dec 2015 13:13:03 GMT

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 — Tue, 08 Dec 2015 13:20:32 GMT

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

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