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

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
priyarane
Specialist
Specialist

Expression

Hi Community,

How to write below expressions

   

expressionif (BS_TYPE = 'OFB', ead, '')
expressionif (BS_TYPE = 'OFB', '', ead)

*ead = sum(ead)

Is it possible in setanalysis

Labels (1)
5 Replies
maleksafa
Specialist
Specialist

you can write it as if(BS_TYPE = 'OFB', sum(ead)) or sum({<BS_TYPE={'OFB'}>}ead)

miguelbraga
Partner - Specialist III
Partner - Specialist III

Try this:

sum({$<BS_TYPE = {'OFB'}>} ead)

Anonymous
Not applicable

=sum({<BS_TYPE={'OFB'} >} ead)

priyarane
Specialist
Specialist
Author

Hi,

I have tried below one

1 expr -

if(BS_TYPE='OFB', (Sum(EAD),0)

2. expr

if(BS_TYPE='OFB',0, (Sum(EAD))

Anonymous
Not applicable

Missing bracket:

1 expr -

if(BS_TYPE='OFB', (Sum(EAD)),0)

2. expr

if(BS_TYPE='OFB',0, (Sum(EAD)))