topic Re: What is Sum(1) ? in QlikView

What is Sum(1) ?

mhmmd_srf — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I am confused in one expression.

If I write sum(1), it is showing some values.

Please check my new sheet in attached App.

Thanks,

Sarif

Re: What is Sum(1) ?

tresB — Tue, 31 Oct 2017 10:56:23 GMT

Using sum(1) across a dimension would mean, summing 1 as many times as the dimension values are there. That is, it would be similar to =Count(YourDimension), i.e. =count(Z_FROM_TIME)

Re: What is Sum(1) ?

techvarun — Tue, 31 Oct 2017 10:57:36 GMT

Sum(1) and count(1) is the frequency of the value in the data model

Re: What is Sum(1) ?

woshua5550 — Tue, 31 Oct 2017 11:05:46 GMT

You can assume that you have a filed "Counter" which contains 1 for each rows of your table "ORD_VOL"

Sum(1) = Sum(Counter) and also

Sum(1) = Count(<one arbitrary field in table ORD_VOL>) , e.g Count(SHIP_LINE_CNT)

in addition Sum(100) = 100 * Count(SHIP_LINE_CNT)