topic Addition and Division Calculation in QlikView

Addition and Division Calculation

Thu, 11 Jun 2015 13:30:53 GMT

Hi,

Can anyone please assist me on this.

I’m trying to add 2 amounts and then divide that by another but the number I get isn’t coming out right.

I have the Commission amount + PiP which is equal to total Income (3,347,518) and then I need to divide that by Volume (29,046) to give me 115.

This is what I’m doing

sum({<[Month-Year] = {">=1<=5"}, [Month-Year] = {'Mar-2015'}, Date =, Week=>} Commission_Amount)+Sum ({<[Month-Year] = {">=1<=5"}, [Month-Year] = {'Mar-2015'}, Date =, Week=>} PIP_Profit_or_Loss) / sum({<[Month-Year] = {">=1<=5"}, [Month-Year] = {'Mar-2015'}, Date =, Week=>}, [Month-Year] = {'Mar-2015'}, Date =, Week=>} Volume)

But I’m getting 1,604,628

Thanks

Yolanda

Re: Addition and Division Calculation

Anonymous — Thu, 11 Jun 2015 15:23:38 GMT

check the brackets properly

Use the whole brackets in the first and second calculation

Re: Addition and Division Calculation

antoniotiman — Thu, 11 Jun 2015 16:25:11 GMT

Hi Yolanda,

Try

(Sum(.......) + Sum(.......)) / Sum(.....)

Regards,

Antonio

Re: Addition and Division Calculation

Fri, 12 Jun 2015 05:52:55 GMT

It Worked!!!

Thank you Antonio 🙂

Re: Addition and Division Calculation

Fri, 12 Jun 2015 05:53:40 GMT

Got it, Thank you Jebmalai 🙂