topic Error in Formula in QlikView

Error in Formula

francisvandergr — Thu, 09 Jun 2011 14:13:42 GMT

Formula below gives an error

=sum( {$<Periode = >}, Grootboeknummer = {7190}>} Grootboekmutatiebedrag) What i want is : the sum of Grootboekbedrag for all periods before the selected period and only from grootboeknummer 7190.

How can i get this ?

I hoop to hear !

Error in Formula

erichshiino — Thu, 09 Jun 2011 14:37:13 GMT

Hi, try this:

=sum( {$<Periode = {'<=$(=only(Periode))'} , Grootboeknummer = {7190}>} Grootboekmutatiebedrag)

If it doesn`t work, we need to check the format of the field Period because, sometimes set analysis will not handle a date in a string format very well..

Hope this helps for now...

Regards,

Erich