Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
alfasierra
Contributor II

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
Valued Contributor II

Excluded value in set analysis

Try this:

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

alfasierra
Contributor II

Excluded value in set analysis

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

Community Browser