topic Re: Expression in QlikView

Expression

Thu, 13 Aug 2015 09:36:27 GMT

Hi Community,

Can we write the below expression in on line

Total Exposure = sum({<BS_TYPE ={'OFB'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)+
sum({<BS_TYPE ={'ASS'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)+
sum({<BS_TYPE -={'ASS','OFB'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)

Thank you

Re: Expression

Gysbert_Wassenaar — Thu, 13 Aug 2015 09:46:29 GMT

sum({<%Month = {'$(vPrevMonth)'}, %Year = {'$(vPrevYear)'}>}EAD)

Re: Expression

sunny_talwar — Thu, 13 Aug 2015 09:51:19 GMT

Or may be this:

=Sum({<BS_TYPE = ,%Month = {'$(vPrevMonth)'}, %Year = {'$(vPrevYear)'}>}EAD)

Re: Expression

Thu, 13 Aug 2015 10:08:00 GMT

Hi Gysbert,

Thanks for the reply..

But I have another BS_Type like BS_Type='XYZ' and so on... I don't wanted to include those

Re: Expression

Gysbert_Wassenaar — Thu, 13 Aug 2015 10:17:12 GMT

You already did in your original expression:

Total Exposure =

Only OFB: sum({<BS_TYPE ={'OFB'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)+

Only ASS: sum({<BS_TYPE ={'ASS'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)+

Everything that's not OFB or ASS: sum({<BS_TYPE -={'ASS','OFB'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)

That means OFB+ASS+(anything not OFB or ASS). On other words every BS_TYPE value

Re: Expression

sasiparupudi1 — Thu, 13 Aug 2015 10:23:32 GMT

sum({<BS_TYPE -={'ASS','OFB','XYZ','ABC','XXX','YYY'},%Month = {'$(=$(=vPrevMonth))'}, %Year = {'$(=$(=vPrevYear))'}>}EAD)