topic Not excluding Negative values in QlikView

Not excluding Negative values

priyarane — Wed, 25 Nov 2020 16:16:04 GMT

Hi Community,

What is the wrong in below expression which is not excluding nagative values. I want negative values should be exclude with the help of(LEV_NETTING_18={"=sum(EAD)-sum(COLL_AMOUNT)>0"}), but it is not doing.

Sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'},LEV_NETTING_18={"=sum(EAD)-sum(COLL_AMOUNT)>0"}>} EBD) -
Sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'},LEV_NETTING_18={"=sum(EAD)-sum(COLL_AMOUNT)>0"}>} COLL_AMOUNT)

Can some one pls suggest

-Priya

Re: Not excluding Negative values

kaushiknsolanki — Thu, 17 Nov 2016 10:16:18 GMT

Hi, Try this

Sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'},LEV_NETTING_18={"=(sum(EAD)-sum(COLL_AMOUNT))>0"}>} EBD) -

Sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'},LEV_NETTING_18={"=(sum(EAD)-sum(COLL_AMOUNT))>0"}>} COLL_AMOUNT)

Regards,

Kaushik Solanki

Re: Not excluding Negative values

MK_QSL — Thu, 17 Nov 2016 10:17:54 GMT

May be this...

Sum(

%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'},

LEV_NETTING_18={"=(sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'}>}EAD)-sum({<%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'}>}COLL_AMOUNT))>0"}

EBD)

Sum(

%YearMonthID={'>=$(=max(%CurrentYearMonthID)-2)<=$(=max(%CurrentYearMonthID))'},

COLL_AMOUNT)

Re: Not excluding Negative values

priyarane — Thu, 17 Nov 2016 11:01:19 GMT

Not working

Re: Not excluding Negative values

priyarane — Thu, 17 Nov 2016 11:01:25 GMT

Not working

Re: Not excluding Negative values

MK_QSL — Thu, 17 Nov 2016 11:04:32 GMT

What is the dimension(s) you have in this chart/table?

Re: Not excluding Negative values

priyarane — Thu, 17 Nov 2016 11:23:07 GMT

%YearMonthID - dim, %CurrentYearMonthID - selection