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: 
Not applicable

Expression format

Hi Community,

I have requirement like below.

1. Label name

if BS_TYPE is not equal to 'ASS' or 'OFB' then name should display like 'EAD expsoure'

2. Exposure

if BS_TYPE is not equal to 'ASS' or 'OFB' then sum of EAD where BS_TYPE = 'ASS' and 'OFB' should not be included.

Please let me know the expression

3 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Is this in a text box, or a chart, or a label somewhere?  What should 'name' display when the condition is not met? What field contains the metric and how do you want that to aggregate?

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
Anonymous
Not applicable
Author

1) if (not ((BS_TYPE='ASS') or (BS_TYPE='OFB')), 'EAD exposure',BS_TYPE)

2) sum({<BSTYPE-={'ASS','OFB'}>}EAD)  -> will always sum without ASS and OFB
   or  ( if (not ((BS_TYPE='ASS') or (BS_TYPE='OFB')), sum(EAD),else) will oly sum if not ASS or OFB

Not applicable
Author

Its a Pivot table