Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

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

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

2 Replies
Not applicable
Author

Created a Combo Chart .

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

Thanks,
Sasi

Not applicable
Author

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