# QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Contributor

## Set Analysis in Script

Hi,

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

),'##.0')

Thanks,

prathip

Tags (2)
Community Browser