Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
ayush0306
Partner - Contributor
Partner - Contributor

working of condition

If(len("Subrogation Potential") = 0,'NA',
if(([MODELID] ='2'and SEGMENT_CHGCD = 'UP'and ([SEGMENTCD] = 'Sig. High' OR [SEGMENTCD] ='High') and SCOREDTS_FLAG = 1),'Y',
'N'))as [SUBRO Promotions],

 

 

how the above condition working?

1 Reply
Saravanan_Desingh

May be see this with indentation.

If(len("Subrogation Potential") = 0,
	'NA',
	if(([MODELID] ='2'and SEGMENT_CHGCD = 'UP'
	and ([SEGMENTCD] = 'Sig. High' 
	OR [SEGMENTCD] ='High') 
	and SCOREDTS_FLAG = 1),
		'Y',
		'N'
	)
) as [SUBRO Promotions],