Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Excluded value in set analysis

Hi to all ,

I have this expression :

=aggr ( sum ( { 1 - $ }  {<Dataven={">=$(=timestamp(div1)) <=$(=timestamp(dfv1))"}>} QtaTot ) , Id_Art )

i want to calculate the sum of QtaTot excluded by the current selection but it NOT work

Where is my mistake?

Thank

2 Replies
fosuzuki
Partner - Specialist III
Partner - Specialist III

Try this:

=aggr ( sum ( { 1 - $ <Dataven={">=$(=timestamp(div1)) <=$(=timestamp(dfv1))"}>} QtaTot ) , Id_Art )

Anonymous
Not applicable
Author

Hi Fernando,

the sintax is correct , the problem is that take out all the value of database , is like

formula considerate 1  ( all database) and not 1-$

thank for your help