topic Sum and Bookmark in QlikView

Sum and Bookmark

Tue, 12 May 2009 17:05:54 GMT

Hi,

I am from Germany and we have Ver 8.5.

i have problem with sum and Bookmark

i have two formel:

1) =Sum({$<Calender.Calender.Year={$(=Only(Calender.Calender.Year))}>}{$*BM01} Billing_Header.Billing_Header.Net_Value_Inv)

2) =Sum({$<Calender.Calender.Year={$(=Only(Calender.Calender.Year)-1)}>}{$*BM01} Billing_Header.Billing_Header.Net_Value_Inv)

In the first formel is Calender year for example 2008 indicated with the bookmark and the Net Value and it work Ok.

into second formel is from 2008-1 = 2007 indicated with the bookmark and the Net Value and the formel put the same value as the first. (2008) it is not possibel Calender.Calender.Year -1 and bookmark.

can anybady help?

Thanks

Regards

Shideh

Regards

Sum and Bookmark

Fri, 15 May 2009 17:48:13 GMT

Hi Shideh

Just a guess here, but you might want to try moving the -1 inside the bracket on the second formula, so it looks like:

=Sum({$<Calendar.Calendar.Year={$(=Only(Calendar.Calendar.Year - 1))}>}{$*BM01} Billing_Header.Billing_Header.Net_Value_Inv)

Hopefully this will help.

Regards,

Nigel.

Sum and Bookmark

Mon, 18 May 2009 20:31:50 GMT

Hi Nigel,

Thanks.