Set Analysis in Script

prathipsrinivas — Mon, 10 Jul 2017 10:43:14 GMT

Hi,

Could you please help me , if there is a chance to write a set analysis expression in the load script.

The set Analysis Expression will look like this

=Num(if((count({<GENDER={'F'},[Candidate Status]={'Onboard'}>}CID)/count({<[Candidate Status]={'Onboard'}>}CID)> 0.445),

if(count({<[level]={13}>}CID) >= 1 , ( 0.20*count({<[level]={13}>}CID) * 1),0) +

if(count({<[level]={12}>}CID) >= 1 , ( 0.20*count({<[level]={12}>}CID) * 1),0) +

if(count({<[level]={11}>}CID) >= 1 , ( 0.20*count({<[level]={11}>}CID) * 1.428),0) +

if(count({<[ level]={10}>}CID) >= 1 , (0.20*count({<[ level]={10}>}CID) * 2),0) +

if(count({<[ level]={9}>}CID) >= 1 , ( 0.20*count({<[level]={9}>}CID) * 3.33),0) +

if(count({<[level]={8}>}CID) >= 1 , ( 0.20*count({<[ level]={8}>}CID) * 5),0)+

if(count({<[level]={7}>}CID) >= 1 , ( 0.20*count({<[ level]={7}>}CID) * 10),0)+

if(count({<[level]={6}>}CID) >= 1 , ( 0.20*count({<[level]={6}>}CID) * 10),0)

),'##.0')

Thanks,

prathip

topic Set Analysis in Script in QlikView