topic Re: Count Acummulated in QlikView

Count Acummulated

pgalvezt — Thu, 12 Feb 2015 15:23:16 GMT

Hi,

I have tried to do the same thing that

But, does't work...

I need that my count be 22 and not 20.

January has 13 registers

February has 11 (2 register that already is in January) so would be 9

13 + 9 = 22...

Thanks!

Anonymous — Thu, 12 Feb 2015 15:48:20 GMT

if you use "Expression total" for the total calculation, then the number is correct

as there are 20 persons in both months

if you Change to a straight table you may Change to "sum of rows" instead of Expression total and you get your numbers.

in Pivot table you may Change the Expression to

=rangesum(count(distinct (cliente_desc)))

pgalvezt — Thu, 12 Feb 2015 15:56:32 GMT

Hi Rudolf,

Still gives rangesum(count(distinct (cliente_desc))) = 20

The sum has to be 22

13 in january

9 in february.

Thu, 12 Feb 2015 16:34:37 GMT

in Feb you have only 7 distinct new clients, not 9. so your distinct count is working

Following 4 client has already registered in Jan.

pgalvezt — Thu, 12 Feb 2015 16:56:35 GMT

I exported Jan (13 registers) and Feb cliente_desc

Feb Appears with 11 registers but 2 repeat registers (Jan). Feb = 9

pgalvezt — Thu, 12 Feb 2015 18:35:43 GMT

Erdal,

Did you do the same thing. If you export jan and feb and then do lookup fuction in excel. you realize that jan has 13 registers and Feb 9.

Thu, 12 Feb 2015 21:36:44 GMT

I believe your VLOOKUP in excel is wrong. Check my screenshot you have 4 clients who are in registered in January and appear in February.

PS: Although this is QV forum, this is the problem in your excel formula.

Your VLOOKUP in excel needs to use absolute cell references in table array.

Check this one.