Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING
cancel
Showing results for 
Search instead for 
Did you mean: 
spividori
Specialist
Specialist

count without movements

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.

4 Replies
QFabian
Specialist II
Specialist II

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

QFabian_0-1606220917149.png

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

QFabian_2-1606221013402.png

 

QFabian
sergio0592
Specialist III
Specialist III

Hi,

Try as calculated dimension

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

and check "Supress when value is null" 

spividori
Specialist
Specialist
Author

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.

spividori
Specialist
Specialist
Author

Any idea?.

 

Regards.