topic Re: Division and Multiplication.... in QlikView

Division and Multiplication....

leocattqv — Tue, 18 Mar 2014 21:58:06 GMT

Hello,

I have 2 sums of Calculations that I am trying to Divide..and multiply

=Sum({<NCMR.Division={'TJM', 'VST'}>} [NCMR.Rej Qty]) / (Sum({<NCMR.Division={'TJM', 'VST'}>})) [No_Approved Parts) *1000000

there is something in the syntax that is tripping me up.

Any suggestions?

thanks,

Leo Catt

Re: Division and Multiplication....

swuehl — Tue, 18 Mar 2014 22:00:14 GMT

=Sum({<NCMR.Division={'TJM', 'VST'}>} [NCMR.Rej Qty]) /

Sum({<NCMR.Division={'TJM', 'VST'}>} [No_Approved Parts]) *1000000

Re: Division and Multiplication....

hic — Tue, 18 Mar 2014 22:01:21 GMT

A mismatch of brackets in [No_Approved Parts)

HIC

Re: Division and Multiplication....

Anonymous — Tue, 18 Mar 2014 22:04:05 GMT

=Sum({<NCMR.Division={'TJM', 'VST'}>} [NCMR.Rej Qty]) / (Sum({<NCMR.Division={'TJM', 'VST'}>})) [No_Approved Parts) *1000000

remove the the second closing parenthesis in the denominator before [No_Approved Parts...also closing parentehsis for the field in the denominator is missing too. try this:

=(Sum({<NCMR.Division={'TJM', 'VST'}>} [NCMR.Rej Qty]) / Sum({<NCMR.Division={'TJM', 'VST'}>} [No_Approved Parts]) )*1000000

i'm assuming you want the result from division to be multiplied with 1000000.