Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
prathipsrinivas
Creator
Creator

Set Analysis in Script

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

),'##.0')

Thanks,

prathip

Prathip
0 Replies