# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for
Did you mean:
Highlighted
Not applicable

## Expression Difference of Value

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

1 Solution

Accepted Solutions
Highlighted
MVP

May be try like this then:

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

Replace Expression1, Expression2 and Dimensions with their respective content

4 Replies
Highlighted
MVP

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

Highlighted
Not applicable

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.

Highlighted
MVP

May be try like this then:

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

Replace Expression1, Expression2 and Dimensions with their respective content

Highlighted
Not applicable

Thanks Sunny. It worked for me. Excellent.