topic Excluded value in set analysis in QlikView

Excluded value in set analysis

Anonymous — Tue, 06 Sep 2011 09:01:33 GMT

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

fosuzuki — Wed, 07 Sep 2011 17:51:54 GMT

Try this:

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

Anonymous — Thu, 08 Sep 2011 06:19:48 GMT

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