Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

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

5 Replies
maleksafa
Specialist
Specialist

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

miguelbraga
Specialist III
Specialist III

Try this:

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

balrajahlawat
Champion
Champion

=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))

balrajahlawat
Champion
Champion

Missing bracket:

1 expr -

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

2. expr

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