Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
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