topic Re: count without movements in QlikView

count without movements

spividori — Tue, 24 Nov 2020 12:09:33 GMT

I need to have 2 tables:
1. Sum (CANT)> 0.
2. Sum (CANT) = 0.
and that when selecting a DATE, it shows the corresponding results in each table.
I need to do it with formulas in the tables, not in the script. These are summary data. The actual base is big.

I attach an example.

Regards.

Re: count without movements

QFabian — Tue, 24 Nov 2020 12:30:03 GMT

Hi @spividori , please check the attached file, i created two tables :

and for the 'CANT = 0' table, please check this part :

Re: count without movements

sergio0592 — Tue, 24 Nov 2020 13:02:04 GMT

Hi,

Try as calculated dimension

=aggr(if(sum(CANT)>0,ID),ID)

and check "Supress when value is null"

Re: count without movements

spividori — Tue, 24 Nov 2020 13:59:40 GMT

Hi.

Thanks for replying, but it doesn't work.
In the image I show that when selecting 08/17/2020 this takes 5 records, these records appear in the table of movements, but I need to separate their do not.
I forgot that I also need to filter them by ACTIVE = S.

I attach excel files with the data I am working on.

Regards.

Re: count without movements

spividori — Tue, 24 Nov 2020 20:25:23 GMT

Any idea?.

Regards.