topic Re: Expression format in QlikView

Expression format

Tue, 04 Aug 2015 07:51:23 GMT

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

Re: Expression format

jonathandienst — Tue, 04 Aug 2015 07:54:36 GMT

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?

Re: Expression format

Anonymous — Tue, 04 Aug 2015 07:55:29 GMT

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

Re: Expression format

Tue, 04 Aug 2015 08:00:41 GMT

Its a Pivot table