Error in Expression Col(2)/Col(1)

Wed, 25 Nov 2020 16:16:04 GMT

Dear QVExperts,

Expression1:

=Sum(Aggr(Sum({<DateType={'Premium'} , MonthYear = {"=MonthYear >=$(vFiscalStartDt) and MonthYear <=$(vFiscalEndDt)"}>} Amount),CERT_SQN,MonthYear,DateType))

Expression2:

=Sum(Aggr(Sum({<DateType={'Claim'} , STATUS_CD = {'L'},MonthYear = {"=MonthYear >=$(vFiscalStartDt) and MonthYear <=$(vFiscalEndDt)"}>} Amount)/Count(MonthYear),CERT_SQN,MonthYear,DateType))

Expression3:

(Column(2) / Column(1))*100

Expression3 displays correctly, if i have like this.

Suppose if i have all three expression as one, then i am not getting correct values.

Sum(Aggr(Sum({<DateType={'Premium'} , MonthYear = {"=MonthYear >=$(vFiscalStartDt) and MonthYear <=$(vFiscalEndDt)"}>} Amount),CERT_SQN,MonthYear,DateType)) /

Sum(Aggr(Sum({<DateType={'Claim'} , STATUS_CD = {'L'},MonthYear = {"=MonthYear >=$(vFiscalStartDt) and MonthYear <=$(vFiscalEndDt)"}>} Amount)/Count(MonthYear),CERT_SQN,MonthYear,DateType))

Can anyone suggest me, what is the mistake in the last expression.

Thanks,
Sasi

Re: Error in Expression Col(2)/Col(1)

Tue, 31 May 2016 18:22:50 GMT

Created a Combo Chart .

Is it possible anyway i can hide Expression1 & Expression. Not Disabled.

Thanks,
Sasi

Re: Error in Expression Col(2)/Col(1)

Tue, 31 May 2016 18:26:42 GMT

Just tried in Colors tab, first two expression in white color.

Then in Expression Tab, the first two expressions, unchecked the Legend.

Now only the third expression is visible in the Combo chart.

Are there any other ways. Please suggest me.

Thanks,
Sasi

topic Error in Expression Col(2)/Col(1) in QlikView

Error in Expression Col(2)/Col(1)

Re: Error in Expression Col(2)/Col(1)

Re: Error in Expression Col(2)/Col(1)