Qlik Community

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 
Search instead for 
Did you mean: 
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

Test1.jpg

1 Solution

Accepted Solutions
Highlighted

May be try like this then:

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

Replace Expression1, Expression2 and Dimensions with their respective content

View solution in original post

4 Replies
Highlighted

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.

Please suggest me

Highlighted

May be try like this then:

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

Replace Expression1, Expression2 and Dimensions with their respective content

View solution in original post

Highlighted
Not applicable

Thanks Sunny. It worked for me. Excellent.