topic Re: Rounding Issues in QlikView

Rounding Issues

santharubban — Thu, 24 Apr 2014 17:41:49 GMT

I am getting rounding issues below,

expression:

Count(IPA_MEMBER_ID) )*
(Round(((COUNT({<NOT_IN_FR = {0},RPT_MON = P({<RPT_MON =,Month=,YEAR=,DOS=>} DOS),SUBMITTER_ID = , CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>} total <TAXONOMY_GROUP> DISTINCT ENCOUNTER_KEY)/
Count({<SUBMITTER_ID = ,RPT_MON = P({<RPT_MON =,Month=,DOS=,YEAR=>} DOS), CLAIM_TYPE= ,REGION =, IPA_Type=,YEAR=,Month=>}total <TAXONOMY_GROUP> IPA_MEMBER_ID))*12),0.01))) /12

Re: Rounding Issues

santharubban — Thu, 24 Apr 2014 17:42:57 GMT

I am getting rounding issues below,

expression:

Re: Rounding Issues

Thu, 24 Apr 2014 18:13:00 GMT

May you share application with sample data?

Re: Rounding Issues

santharubban — Thu, 24 Apr 2014 18:40:02 GMT

i have attached screen shot

Re: Rounding Issues

Thu, 24 Apr 2014 18:43:11 GMT

I saw it. But i would like to look into application ....

Re: Rounding Issues

MK_QSL — Thu, 24 Apr 2014 19:19:19 GMT

Instead of Round(YourExpression,0.01) use

Floor(YourExpression)

Re: Rounding Issues

santharubban — Thu, 24 Apr 2014 19:33:14 GMT

I already try, not working

Re: Rounding Issues

MK_QSL — Thu, 24 Apr 2014 19:38:14 GMT

please upload sample apps

Re: Rounding Issues

santharubban — Thu, 24 Apr 2014 20:04:20 GMT

pls find attachement

Re: Rounding Issues

sundarakumar — Thu, 24 Apr 2014 20:06:29 GMT

couldn't find any attachment. can u pls check.

-Sundar

Re: Rounding Issues

Thu, 24 Apr 2014 20:20:22 GMT

To try to find the issue, we must view it in the application, not in the picture.

It will be the easiest.
You do not need to share real data ....

Re: Rounding Issues

santharubban — Thu, 24 Apr 2014 20:22:05 GMT

Data is too big that why i couldn't attached. pls find sample

Re: Rounding Issues

Thu, 24 Apr 2014 20:34:43 GMT

load less rows of course ...

only as many as is needed to reproduce problem

Re: Rounding Issues

santharubban — Thu, 24 Apr 2014 20:42:01 GMT

pls find the attachement

Re: Re: Rounding Issues

Thu, 24 Apr 2014 21:03:23 GMT

I understand, that you have problem with total result of Expected Claim ...

i added partial results, and they looks ok.

Look:

Re: Rounding Issues

santharubban — Fri, 25 Apr 2014 13:04:01 GMT

thanks Dariusz... Can you pls tell me how to added Partial results.

Re: Rounding Issues

Fri, 25 Apr 2014 13:11:45 GMT

I took your expression for Expected Claim and created few additional expression from it with partial calculations to look what values are there. Take a look on attached application.

regards

Darek