topic Re: Expression Difference of Value in QlikView

Expression Difference of Value

Wed, 25 Nov 2020 16:16:04 GMT

Dear QVExperts,

In the straight table below,

Expression1, as Claim Count [ There are total 5 claim counts]

Expression2, which shows the value whether claim there or not.

Expression3 as Column(1)/Column(2)

Now i need to display as 5 / 313.33 as 1.6 in the cumulative total.

But i am getting as 22.162

Can anyone suggest me on this.

Thanks,

Sasi

sunny_talwar — Wed, 08 Jun 2016 19:12:54 GMT

Are you using a total mode here? I think setting the total mode to expression total should do it. Can you try doing that?

Wed, 08 Jun 2016 19:17:57 GMT

Hi Sunny,

Hope you are doing great.

Expression Total, the Expression2 itself not displaying correctly.

{here i am taking the day differences between the retrieval divided by total number of days for a year]

((IF([EXT_WRNTY_STR_DT]>$(vFiscalEndDt),0,

IF([EXT_WRNTY_END_DT]<$(vFiscalStartDt),0,

IF([EXT_WRNTY_END_DT]<$(vFiscalStartDt),$(vFiscalStartDt),

IF([EXT_WRNTY_END_DT]>$(vFiscalEndDt),$(vFiscalEndDt),[EXT_WRNTY_END_DT]))))

IF([EXT_WRNTY_STR_DT]<$(vFiscalStartDt),$(vFiscalStartDt),

IF([EXT_WRNTY_STR_DT]>$(vFiscalEndDt),$(vFiscalEndDt),[EXT_WRNTY_STR_DT]))+1)

DayCount )

That's why Expression3 going for Sum of Rows.

Please suggest me

sunny_talwar — Wed, 08 Jun 2016 19:57:36 GMT

May be try like this then:

Sum(Aggr(Expression1, Dimensions))/Sum(Aggr(Expression2, Dimensions))

Replace Expression1, Expression2 and Dimensions with their respective content

Thu, 09 Jun 2016 07:27:07 GMT

Thanks Sunny. It worked for me. Excellent.