topic Re: Expression not displaying correctly !!! in QlikView

Expression not displaying correctly !!!

Wed, 25 Nov 2020 16:16:04 GMT

Dear QV Experts,

Two Straight Tables,

1) With Certificate No, displaying the Earned Premium Correctly.

2) Without Certificate No, Not displaying Earned Premium Correctly.

Please find the screenshot below,

Please suggest me. Enclosed the QVW.

Re: Expression not displaying correctly !!!

marcus_sommer — Thu, 12 May 2016 09:58:09 GMT

Without the dimension Certificate_No you need an aggr-function to calculate the expression on this level and you need to include all necessary dimensions - in your case the Certificate_No and Date.

=If (MonthYear < $(vFiscalStartDt),0,

If (MonthYear > $(vFiscalEndDt),0,

sum(aggr((Sum(distinct Premium_Amt)/365) * Count( DISTINCT Date), Certificate_No, Date))))

- Marcus

Re: Expression not displaying correctly !!!

Thu, 12 May 2016 10:13:10 GMT

Thanks a lot. It worked.