topic Re: Error in Text Box Calculation in QlikView

Error in Text Box Calculation

upaliwije — Thu, 04 May 2017 09:15:26 GMT

I have the following chart in my QV Doc

In the above Text Box (last one 28%)I want to calculate figure 1713182/4441686=38% But I get the answer as 28%

My expression is as follows

=NUM(((sum({<MO_NM={'MOTOR'},MONTH={'MAR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))))

(sum({<MO_NM={'MOTOR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))/3))

/ fabs(sum({<MO_NM={'MOTOR'},MONTH={'MAR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))),'#,##0 %')

Pls advise What Mistake I have done and corret me

Re: Error in Text Box Calculation

Anil_Babu_Samineni — Thu, 04 May 2017 09:34:23 GMT

Are you sure, You are using same which existing for 2 values

Would you able to share me sample applicaiton

Re: Error in Text Box Calculation

prieper — Thu, 04 May 2017 10:05:18 GMT

Think that you have three values involved. A-B/C?

Suggest to

a) take out the formatting (this might be done as last step)

b) copy the formulas from each box but add parethesis for each expression and calculate A/B

Peter

Re: Error in Text Box Calculation

upaliwije — Thu, 04 May 2017 10:10:10 GMT

Can you pls write the suggested expression

Re: Error in Text Box Calculation

prieper — Thu, 04 May 2017 10:20:54 GMT

there are three parts in your view, am not sure, whether the brackets are correct.

Am neither sure, whether the combination of SUM(....RANGESUM(....)) works.

Re: Error in Text Box Calculation

vinieme12 — Thu, 04 May 2017 10:26:42 GMT

Can i suggest you simply copy paste the expressions you used in Textbox 1 and Textbox 2 directly as below

Textbox3 = Texbox2 / Textbox1 ??

Re: Error in Text Box Calculation

upaliwije — Thu, 04 May 2017 10:27:12 GMT

This is the sample data pls advise.

Re: Error in Text Box Calculation

Anil_Babu_Samineni — Thu, 04 May 2017 10:38:30 GMT

Check this, It's working for me

=Num((NUM((sum({<MO_NM={'MOTOR'},MONTH={'MAR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))) - (sum({<MO_NM={'MOTOR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))/3),'#,##0')) /

(NUM(sum({<MO_NM={'MOTOR'}>}(rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE)))/3,'#,##0.')),'#,#0%')