Solved: Which is correct: sum(sales/10000) or sum(sales)/1... - Qlik Community

ananyaghosh · ‎2017-03-29

Hi,

Please give me a suggestion that which is the correct way to use sum function:

sum(sales/10000)

or

sum(sales)/10000

and I have noticed that value is changed for some data.

Please suggest with an example.

Thanks,

Sandip

jonathandienst · ‎2017-03-29

Its largely a matter of style. The second one is marginally more efficient and may execute slightly faster and this will be more important if the data set is large. So I would generally move the constant out of the sum().

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

View solution in original post

awhitfield · ‎2017-03-29

the second one

Andy

Anonymous · ‎2017-03-29

Hi Sandeep,

As we are using sum here, both shouldn't make any difference. And choosing the correct way depends on the requirement.

jonathandienst · ‎2017-03-29

Its largely a matter of style. The second one is marginally more efficient and may execute slightly faster and this will be more important if the data set is large. So I would generally move the constant out of the sum().

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein

Which is correct: sum(sales/10000) or sum(sales)/10000?